-
[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
![Asus H110M-K LGA 1151 DDR4 USB 3.0 Micro ATX Intel Desktop Motherboard w/IO picture](/store/img/g/L5MAAOSweLJmgxph/s-l225/Asus-H110M-K-LGA-1151-DDR4-USB-3-0-Micro-ATX-Intel.jpg)
Asus H110M-K LGA 1151 DDR4 USB 3.0 Micro ATX Intel Desktop Motherboard w/IO
$34.95
![Gigabyte Z370P D3 ATX Z370 LGA1151 Motherboard (Support Intel 6/7th 8th 9th) picture](/store/img/g/QrkAAOSwMGNmLxf0/s-l225/Gigabyte-Z370P-D3-ATX-Z370-LGA1151-Motherboard-Sup.jpg)
Gigabyte Z370P D3 ATX Z370 LGA1151 Motherboard (Support Intel 6/7th 8th 9th)
$59.99
![ASRock B550M Pro SE AM4 DDR4 SATA 6Gb/s 1 PCIe 4.0 x16 Micro ATX Motherboard picture](/store/img/g/oXIAAOSwCn1k30lD/s-l225/ASRock-B550M-Pro-SE-AM4-DDR4-SATA-6Gb-s-1-PCIe-4-0.jpg)
ASRock B550M Pro SE AM4 DDR4 SATA 6Gb/s 1 PCIe 4.0 x16 Micro ATX Motherboard
$84.99
![Asus H81M-C Intel LGA1150 DDR3 Desktop Motherboard MicroATX Socket H3 picture](/store/img/g/CZ4AAOSwg8pmYirU/s-l225/Asus-H81M-C-Intel-LGA1150-DDR3-Desktop-Motherboard.jpg)
Asus H81M-C Intel LGA1150 DDR3 Desktop Motherboard MicroATX Socket H3
$23.99
![ASUS H110M-R Motherboard Intel 6th/7th Gen LGA1151 DDR4 Micro-ATX i/o shield picture](/store/img/g/FhQAAOSwzL9iDqc3/s-l225/ASUS-H110M-R-Motherboard-Intel-6th-7th-Gen-LGA1151.jpg)
ASUS H110M-R Motherboard Intel 6th/7th Gen LGA1151 DDR4 Micro-ATX i/o shield
$42.00
![Asus Prime H310M-A R2.0 Intel LGA 1151 DDR4 Desktop Motherboard picture](/store/img/g/GysAAOSwgVNmhZ8u/s-l225/Asus-Prime-H310M-A-R2-0-Intel-LGA-1151-DDR4-Deskto.jpg)
Asus Prime H310M-A R2.0 Intel LGA 1151 DDR4 Desktop Motherboard
$54.99
![NEW OEM ASRock H410M/MC LGA1200 Intel M-ATX Motherboard (Wifi) picture](/store/img/g/mUUAAOSwbGNmgEvT/s-l225/NEW-OEM-ASRock-H410M-MC-LGA1200-Intel-M-ATX-Mother.jpg)
NEW OEM ASRock H410M/MC LGA1200 Intel M-ATX Motherboard (Wifi)
$49.99
![ASRock H170 Pro4S Motherboard ATX Intel H170 LGA1151 DDR4 SATA3 HDMI picture](/store/img/g/guoAAOSwk7lmex9j/s-l225/ASRock-H170-Pro4S-Motherboard-ATX-Intel-H170-LGA11.jpg)
ASRock H170 Pro4S Motherboard ATX Intel H170 LGA1151 DDR4 SATA3 HDMI
$39.99
![Gigabyte M-ATX motherboard with Intel Core i3 8100 CPU and 8GB DDR4 RAM picture](/store/img/g/CCsAAOSw9mtkQuoe/s-l225/Gigabyte-M-ATX-motherboard-with-Intel-Core-i3-8100.jpg)
Gigabyte M-ATX motherboard with Intel Core i3 8100 CPU and 8GB DDR4 RAM
$84.00
![ASUS PRIME Z690-P WIFI D4 ATX Motherboard Intel LGA1700 DDR4 HDMI picture](/store/img/g/gR8AAOSwhlJkracH/s-l225/ASUS-PRIME-Z690-P-WIFI-D4-ATX-Motherboard-Intel-LG.jpg)
ASUS PRIME Z690-P WIFI D4 ATX Motherboard Intel LGA1700 DDR4 HDMI
$99.99