-
[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
![Samsung - 990 EVO SSD 1TB Internal SSD PCIe Gen 4x4 | Gen 5x2 M.2 2280, Speed... picture](/store/img/b4QAAOSw~BxmhcGU/s-l225//Samsung-990-EVO-SSD-1TB-Internal-SSD-PCIe-Gen-4x4-.jpg)
Samsung - 990 EVO SSD 1TB Internal SSD PCIe Gen 4x4 | Gen 5x2 M.2 2280, Speed...
$59.00
![1TB/2TB USB 3.0 Flash Drive Thumb U Disk Memory Stick Pen PC Laptop Storage lot picture](/store/img/PDMAAOSwlhdmFJ5R/s-l225//1TB-2TB-USB-3-0-Flash-Drive-Thumb-U-Disk-Memory-St.jpg)
1TB/2TB USB 3.0 Flash Drive Thumb U Disk Memory Stick Pen PC Laptop Storage lot
$80.39
![Seagate ST1000VM002 1TB 64MB SATA6Gb/s 3.5](/store/img/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
![Monterey - Apple MacBook Pro 15](/store/img/ncAAAOSwOhZmmVVX/s-l225//Monterey-Apple-MacBook-Pro-15-1TB-SSD-16GB-i7-3-40.jpg)
Monterey - Apple MacBook Pro 15" 1TB SSD 16GB i7 3.40Ghz Retina - ALLSTATE
$475.00
![Patriot P210 128GB 256GB 512GB 1TB 2TB 2.5](/store/img/RzIAAOSwSZNlN-zB/s-l225//Patriot-P210-128GB-256GB-512GB-1TB-2TB-2-5-SATA-3-.jpg)
Patriot P210 128GB 256GB 512GB 1TB 2TB 2.5" SATA 3 6GB/s Internal SSD PC/MAC Lot
$19.99
![1TB SATA 3.5](/store/img/17UAAOSwB2lmkGOs/s-l225//1TB-SATA-3-5-HDD-Mixed-Brand-Mixed-Speed-WD-HGST-S.jpg)
1TB SATA 3.5" HDD Mixed Brand Mixed Speed WD HGST Seagate Hitachi
$12.95
![Western Digital WD Blue WD10EZEX 1 TB 3.5](/store/img/HzQAAOSwN6hmnfx1/s-l225//Western-Digital-WD-Blue-WD10EZEX-1-TB-3-5-SATA-III.jpg)
Western Digital WD Blue WD10EZEX 1 TB 3.5" SATA III Desktop Hard Drive
$19.99
![Samsung - Geek Squad Certified Refurbished 870 EVO 1TB SATA Solid State Drive picture](/store/img/25EAAOSw2gplntqr/s-l225//Samsung-Geek-Squad-Certified-Refurbished-870-EVO-1.jpg)
Samsung - Geek Squad Certified Refurbished 870 EVO 1TB SATA Solid State Drive
$67.99
![Lenovo Legion Pro 7i 16](/store/img/K1kAAOSwSOhmmdru/s-l225//Lenovo-Legion-Pro-7i-16-WQXGA-240Hz-Gaming-Laptop-.jpg)
Lenovo Legion Pro 7i 16" WQXGA 240Hz Gaming Laptop i9-14900HX 16GB RAM RTX 4080
$37.98
![Type C USB 3.0 Flash Drive Thumb Drive Memory Stick for PC Laptop 1TB 2TB lot picture](/store/img/oroAAOSwsJNmFPcr/s-l225//Type-C-USB-3-0-Flash-Drive-Thumb-Drive-Memory-Stic.jpg)
Type C USB 3.0 Flash Drive Thumb Drive Memory Stick for PC Laptop 1TB 2TB lot
$73.29