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
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
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
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.Originally Posted by Coume
[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
ORICO 5 Bay Raid Enclosure USB3.0 SATA External Hard Drive Enclosure Up to 80TB
$115.59
ORICO 5 Bay Raid USB3.0 to SATA External Hard Drive Enclosure for 3.5'' HDD LOT
$140.79
LaCie 5BIG NETWORK 2 5-bay RAID HDD Bay [ SEE DESCRIPTION ]
$119.99
ACASIS 2.5/3.5 inch 2 Bay SATA USB 3.0 Hard Drive Disk HDD SSD Enclosure 4 RAID
$54.27
Inspur LSI 9300-8i Raid Card 12Gbps HBA HDD Controller High Profile
$15.98
Inspur LSI YZCA-00424-101 Raid Card 12Gbps HBA Controller Low Profile 9300-8i IT
$15.98
Dell H2R6M PowerEdge PERC H700 6Gb/s 512MB SAS RAID Controller
$19.99
Dell PERC H330 PCIe 3.0 x8 RAID Storage Controller 4Y5H1 High Profile
$14.99
Yottamaster 2 Bay RAID Hard Drive Enclosure USB 3.1 For 2.5" SATA HDD SSD UASP
$56.25
HDD Enclosure USB 3.0 2.5 inch Dual Bay 2*6TB HDD RAID SATA Hard Drive Enclosure
$32.69