[MySQL] Export a DB From PHPMyAdmin to /var/lib/mysql

[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

I did not find how to do that...
I manage to create an empty DB but that's it :(

Thxs
Ludo

[MadWebGuru]

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

[Coume]

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

[MadWebGuru]

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

[Edwin]

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.


According to their faq you can transfer the backup directly to your machine


- - Edwin

[Coume]

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