-
[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
![Vintage 1980s Microcomputer 5.25” Floppy Disk Organizer Storage Roll Top Carry picture](/store/img/fEMAAOSwCHZmnboi/s-l225//Vintage-1980s-Microcomputer-5-25-Floppy-Disk-Organ.jpg)
Vintage 1980s Microcomputer 5.25” Floppy Disk Organizer Storage Roll Top Carry
$20.00
![Apple Computer Vintage sheet of 1990s rainbow logo stickers 2 Sticker Sheet picture](/store/img/DCIAAOSwsfdmgYEX/s-l225//Apple-Computer-Vintage-sheet-of-1990s-rainbow-logo.jpg)
Apple Computer Vintage sheet of 1990s rainbow logo stickers 2 Sticker Sheet
$4.80
![Vintage Compaq 141649-004 2 Button PS/2 Gray Mouse M-S34 - FAST SHIPPING - NEW picture](/store/img/hxcAAOSwZ~pdrx9T/s-l225//Vintage-Compaq-141649-004-2-Button-PS-2-Gray-Mouse.jpg)
Vintage Compaq 141649-004 2 Button PS/2 Gray Mouse M-S34 - FAST SHIPPING - NEW
$8.99
![Vintage Dot Matrix Printer Contin Feed Paper 8.5 x 11. Lots of 5 to 250 sheets. picture](/store/img/498AAOSwJTdl1MqH/s-l225//Vintage-Dot-Matrix-Printer-Contin-Feed-Paper-8-5-x.jpg)
Vintage Dot Matrix Printer Contin Feed Paper 8.5 x 11. Lots of 5 to 250 sheets.
$4.00
![Vintage ESS 1869 2-Channel Sound Card (New) picture](/store/img/bMQAAOSwmGRmkBXI/s-l225//Vintage-ESS-1869-2-Channel-Sound-Card-New-.jpg)
Vintage ESS 1869 2-Channel Sound Card (New)
$19.99
![Power Cord 3 Pin Oval Vintage Style 7amp 125vac Belden 7 Foot Grey picture](/store/img/R~IAAOSwJuxmgIwG/s-l225//Power-Cord-3-Pin-Oval-Vintage-Style-7amp-125vac-Be.jpg)
Power Cord 3 Pin Oval Vintage Style 7amp 125vac Belden 7 Foot Grey
$25.00
![NEW Manufacture OLD STYLE Oval 3 Prong Power Cord HP style 125V 7A 875W Vintage picture](/store/img/M1IAAOSwoHlkXVZf/s-l225//NEW-Manufacture-OLD-STYLE-Oval-3-Prong-Power-Cord-.jpg)
NEW Manufacture OLD STYLE Oval 3 Prong Power Cord HP style 125V 7A 875W Vintage
$39.95
![Vintage Computing Books picture](/store/img/i4kAAOSw0l9mnXWD/s-l225//Vintage-Computing-Books.jpg)
Vintage Computing Books
$9.95
![Rare Vintage Collectible Apple M5769 Optical Pro Mouse - White M9035G/A NEW (#21 picture](/store/img/DOcAAOSwRo5mnZHB/s-l225//Rare-Vintage-Collectible-Apple-M5769-Optical-Pro-M.jpg)
Rare Vintage Collectible Apple M5769 Optical Pro Mouse - White M9035G/A NEW (#21
$69.95
![Twelve South BookBook Case for iPad Mini 6 | Hardback Leather Vintage Brown picture](/store/img/SUkAAOSwgopmm1CJ/s-l225//Twelve-South-BookBook-Case-for-iPad-Mini-6-Hardbac.jpg)
Twelve South BookBook Case for iPad Mini 6 | Hardback Leather Vintage Brown
$39.99