-
[MySQL] Export a DB From PHPMyAdmin to /var/lib/mysql
Hello,
I would like to know if it is possible to export my actual DB from my website that I manage with PHPmyadmin to copy it into my /var/lib/mysql
I did not find how to do that...
I manage to create an empty DB but that's it ![Sad](images/smilies/icon_sad.gif)
Thxs
Ludo
-
Hope this helps,
What I did was setup a script that actually deletes the httpd.conf and php.ini files, and then creates links to my database folders and config files that are stored on my pen memory device. This way, I don't lose any of the data during a reboot.
#!/bin/sh
chmod 777 -R /etc/apache
chmod 777 -R /var/www
chmod 777 -R /etc/php4/apache
rm /etc/apache/httpd.conf
rm /etc/php4/apache/php.ini
ln -s /mnt/sda1/httpd.conf /etc/apache/httpd.conf
ln -s /mnt/sda1/htdocs /var/www/htdocs
ln -s /mnt/sda1/php.ini /etc/php4/apache/php.ini
apachectl start
chmod 777 -R /var/lib/mysql
ln -s /mnt/sda1/citydata /var/lib/mysql/citydata
/usr/bin/mysqld_safe &
echo "Done with setup"
MadWebGuru
Bruce
-
Hmm that's not exactly what I meant.
Perhaps I should try to post it on the HDD install. Because I've knoppix installed on my HDD.
thxs anyway
-
I just copied the actual files over from a different box.
Using the script I provided, you could create a empty folder that is linked into the /var/lib/mysql and then use phpMyAdmin to import a exported dump. The dump should contain the sql needed to define the tables for your database.
MadWebGuru
Bruce
-
Re: [MySQL] Export a DB From PHPMyAdmin to /var/lib/mysql
![Quote](images/misc/quote_icon.png)
Originally Posted by
Coume
Hello,
I would like to know if it is possible to export my actual DB from my website that I manage with PHPmyadmin to copy it into my /var/lib/mysql
According to www.phpmyadmin.net you can make a backup. Now the problem can be how to ftp those backups over, but that depends on the setup on your remote host.
[Edit]
According to their faq you can transfer the backup directly to your machine
[/Edit]
- - Edwin
-
hi,
Ok I'll try to have a deeper look into myphpadmin and see if my host allow to export the data too...
thxs
Ludo
Similar Threads
-
By mzee in forum Knoppix DVD
Replies: 17
Last Post: 10-12-2005, 08:48 AM
-
By sbb in forum General Support
Replies: 3
Last Post: 12-28-2004, 05:14 AM
-
By dr_rude in forum General Support
Replies: 2
Last Post: 10-11-2004, 02:37 AM
-
By Coume in forum Hdd Install / Debian / Apt
Replies: 3
Last Post: 08-04-2003, 07:00 AM
-
By Terry@nz in forum General Support
Replies: 3
Last Post: 06-09-2003, 10:01 PM
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
![Seagate Exos X22 ST22000NM001E 22TB 512E SATA 6Gb/s 3.5](/store/img/g/LfgAAOSw9~1l-F1x/s-l225/Seagate-Exos-X22-ST22000NM001E-22TB-512E-SATA-6Gb-.jpg)
Seagate Exos X22 ST22000NM001E 22TB 512E SATA 6Gb/s 3.5" Enterprise Hard Drive
$311.99
![HITACHI HUS724040ALA640 4TB 7200RPM 64MB SATA 6.0Gb/s 3.5](/store/img/g/TIMAAOSw969gDuvf/s-l225/HITACHI-HUS724040ALA640-4TB-7200RPM-64MB-SATA-6-0G.jpg)
HITACHI HUS724040ALA640 4TB 7200RPM 64MB SATA 6.0Gb/s 3.5" HARD DRIVE ZERO HOURS
$52.00
![Seagate ST8000NM0055 8TB 7200RPM 256MB SATA 6.0 Gb/s 3.5](/store/img/g/xy8AAOSwuMhl8Y7x/s-l225/Seagate-ST8000NM0055-8TB-7200RPM-256MB-SATA-6-0-Gb.jpg)
Seagate ST8000NM0055 8TB 7200RPM 256MB SATA 6.0 Gb/s 3.5" Enterprise Hard Drive
$34.29
![HGST Ultrastar DC HC520 12TB SATA 6Gb 256MB 3.5](/store/img/g/buwAAOSwDghlwalj/s-l225/HGST-Ultrastar-DC-HC520-12TB-SATA-6Gb-256MB-3-5-En.jpg)
HGST Ultrastar DC HC520 12TB SATA 6Gb 256MB 3.5" Enterprise HDD- HUH721212ALE601
$82.99
![HGST Ultrastar HE10 10TB SATA 6.0Gb/s 7200 3.5](/store/img/g/2NYAAOSwj9hkeS1e/s-l225/HGST-Ultrastar-HE10-10TB-SATA-6-0Gb-s-7200-3-5-Dat.jpg)
HGST Ultrastar HE10 10TB SATA 6.0Gb/s 7200 3.5" Datacenter HDD - HUH721010ALE601
$79.99
![Seagate ST12000NM0127 12TB 256MB 7200RPM 3.5](/store/img/g/ZyMAAOSw4ullEigP/s-l225/Seagate-ST12000NM0127-12TB-256MB-7200RPM-3-5-SATA-.jpg)
Seagate ST12000NM0127 12TB 256MB 7200RPM 3.5" SATA 6.0Gb/s Enterprise Hard Drive
$87.99
![WD Ultrastar DC HC530 14TB SATA 6G 3.5](/store/img/g/gggAAOSwwB5mL~fg/s-l225/WD-Ultrastar-DC-HC530-14TB-SATA-6G-3-5-7200RPM-Ent.jpg)
WD Ultrastar DC HC530 14TB SATA 6G 3.5" 7200RPM Enterprise HDD - WUH721414ALE604
$110.00
![Seagate ST12000NM0127 12TB SATA 6Gb/s 256MB 7200RPM 3.5](/store/img/g/de0AAOSwcJJlDe~2/s-l225/Seagate-ST12000NM0127-12TB-SATA-6Gb-s-256MB-7200RP.jpg)
Seagate ST12000NM0127 12TB SATA 6Gb/s 256MB 7200RPM 3.5" Enterprise Hard Drive
$99.99
![WD 5TB Certified Refurbished Elements, External Hard Drive - RWDBU6Y0050BBK-WESN picture](/store/img/g/Z6wAAOSwGGllvNab/s-l225/WD-5TB-Certified-Refurbished-Elements-External-Har.jpg)
WD 5TB Certified Refurbished Elements, External Hard Drive - RWDBU6Y0050BBK-WESN
$78.99
![Seagate ST1000VM002 1TB 64MB SATA6Gb/s 3.5](/store/img/g/tFMAAOSwjDVmceFV/s-l225/Seagate-ST1000VM002-1TB-64MB-SATA6Gb-s-3-5-Low-Pow.jpg)
Seagate ST1000VM002 1TB 64MB SATA6Gb/s 3.5" (Low Power) Hard Drive -PC, CCTV DVR
$24.99