-
[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
![256GB Kit (8 x 32GB) PC4-17000 LRDIMM DELL POWEREDGE R730xd R730 R630 Memory RAM picture](/store/img/g/EeAAAOSwubRXNRbz/s-l225/256GB-Kit-8-x-32GB-PC4-17000-LRDIMM-DELL-POWEREDGE.jpg)
256GB Kit (8 x 32GB) PC4-17000 LRDIMM DELL POWEREDGE R730xd R730 R630 Memory RAM
$255.92
![A-Tech 8GB DDR3 1600 PC3-12800 Laptop SODIMM 204-Pin Memory RAM PC3L DDR3L 1x 8G picture](/store/img/g/RCAAAOSweqdeWaui/s-l225/A-Tech-8GB-DDR3-1600-PC3-12800-Laptop-SODIMM-204-P.jpg)
A-Tech 8GB DDR3 1600 PC3-12800 Laptop SODIMM 204-Pin Memory RAM PC3L DDR3L 1x 8G
$13.99
![Samsung 8GB - 1Rx8 - PC4-2666V Desktop RAM Memory | M378A1K43CB2-CTD picture](/store/img/g/8JEAAOSwn79mhBvi/s-l225/Samsung-8GB-1Rx8-PC4-2666V-Desktop-RAM-Memory-M378.jpg)
Samsung 8GB - 1Rx8 - PC4-2666V Desktop RAM Memory | M378A1K43CB2-CTD
$9.99
![8GB PC3L-12800S 1600MHz SODIMM DDR3 RAM | Grade A picture](/store/img/g/tmAAAOSwxu1mDNSQ/s-l225/8GB-PC3L-12800S-1600MHz-SODIMM-DDR3-RAM-Grade-A.jpg)
8GB PC3L-12800S 1600MHz SODIMM DDR3 RAM | Grade A
$12.00
![Crucial DDR3L 16GB 1600 2x 8GB PC3-12800 Laptop SODIMM Memory RAM PC3 16G DDR3 picture](/store/img/g/mecAAOSw2Vlkv6Ot/s-l225/Crucial-DDR3L-16GB-1600-2x-8GB-PC3-12800-Laptop-SO.jpg)
Crucial DDR3L 16GB 1600 2x 8GB PC3-12800 Laptop SODIMM Memory RAM PC3 16G DDR3
$13.50
![Team T-FORCE VULCAN Z 32GB (2 x 16GB) PC RAM DDR4 3200 (PC4 25600) Memory picture](/store/img/g/~u4AAOSwK-liKn7t/s-l225/Team-T-FORCE-VULCAN-Z-32GB-2-x-16GB-PC-RAM-DDR4-32.jpg)
Team T-FORCE VULCAN Z 32GB (2 x 16GB) PC RAM DDR4 3200 (PC4 25600) Memory
$54.99
![Team T-FORCE VULCAN Z 16GB (2 x 8GB) 288-Pin PC RAM DDR4 3200 (PC4 25600) Intel picture](/store/img/g/uPEAAOSw0-1mBgnN/s-l225/Team-T-FORCE-VULCAN-Z-16GB-2-x-8GB-288-Pin-PC-RAM-.jpg)
Team T-FORCE VULCAN Z 16GB (2 x 8GB) 288-Pin PC RAM DDR4 3200 (PC4 25600) Intel
$33.99
![HyperX FURY DDR3 8GB 16GB 32GB 1600 MHz PC3-12800 Desktop RAM Memory DIMM 240pin picture](/store/img/g/XNYAAOSwg81kv6CG/s-l225/HyperX-FURY-DDR3-8GB-16GB-32GB-1600-MHz-PC3-12800-.jpg)
HyperX FURY DDR3 8GB 16GB 32GB 1600 MHz PC3-12800 Desktop RAM Memory DIMM 240pin
$15.90
![Kingston HyperX FURY DDR3 8GB 16GB 32G 1600 1866 1333 Desktop Memory RAM DIMM picture](/store/img/g/DWUAAOSw5e1kv6CT/s-l225/Kingston-HyperX-FURY-DDR3-8GB-16GB-32G-1600-1866-1.jpg)
Kingston HyperX FURY DDR3 8GB 16GB 32G 1600 1866 1333 Desktop Memory RAM DIMM
$38.95
![Hynix 64GB 2Rx4 PC4-3200 RDIMM DDR4-25600 ECC REG Registered Server Memory RAM picture](/store/img/g/9nQAAOSwpFRkAmU7/s-l225/Hynix-64GB-2Rx4-PC4-3200-RDIMM-DDR4-25600-ECC-REG-.jpg)
Hynix 64GB 2Rx4 PC4-3200 RDIMM DDR4-25600 ECC REG Registered Server Memory RAM
$129.99