[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.

[Edit]
According to their faq you can transfer the backup directly to your machine
[/Edit]

- - 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