-
[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
![Commodore Amiga 4000 Lot With Disks, Cords, Manuals, Accessories, All Untested picture](/store/img/g/Dg8AAOSw4BlmhACc/s-l225/Commodore-Amiga-4000-Lot-With-Disks-Cords-Manuals-.jpg)
Commodore Amiga 4000 Lot With Disks, Cords, Manuals, Accessories, All Untested
$4500.00
![Commodore CDTV Professional CD1500 Kit picture](/store/img/g/s8YAAOSw4zxmhHpf/s-l225/Commodore-CDTV-Professional-CD1500-Kit.jpg)
Commodore CDTV Professional CD1500 Kit
$799.99
![Commodore 64 Computer True mint in box with joystick and Donkey Kong working picture](/store/img/g/6d4AAOSwtydmhLNO/s-l225/Commodore-64-Computer-True-mint-in-box-with-joysti.jpg)
Commodore 64 Computer True mint in box with joystick and Donkey Kong working
$349.00
![WORKING Commodore 128 C128 Computer With Box Manual PSU READ Retro Gaming picture](/store/img/g/J0YAAOSwyuRmg3Vt/s-l225/WORKING-Commodore-128-C128-Computer-With-Box-Manua.jpg)
WORKING Commodore 128 C128 Computer With Box Manual PSU READ Retro Gaming
$275.88
![Data 20 - XL 80 - Commodore 64 C64 100% Complete picture](/store/img/g/7P8AAOSwqT9mhGl5/s-l225/Data-20-XL-80-Commodore-64-C64-100-Complete-.jpg)
Data 20 - XL 80 - Commodore 64 C64 100% Complete
$150.00
![6FT TV AV Audio Video 8Pin DIN 3 RCA Composite Cable For Commodore 64 128 16 +4 picture](/store/img/g/b7IAAOSwc8BmQ03T/s-l225/6FT-TV-AV-Audio-Video-8Pin-DIN-3-RCA-Composite-Cab.jpg)
6FT TV AV Audio Video 8Pin DIN 3 RCA Composite Cable For Commodore 64 128 16 +4
$9.99
![CMD FD-2000 1.6MB HD Disk Drive For 8-bit Commodore 64/128, Tested, Working picture](/store/img/g/zFgAAOSwWEdmhI6u/s-l225/CMD-FD-2000-1-6MB-HD-Disk-Drive-For-8-bit-Commodor.jpg)
CMD FD-2000 1.6MB HD Disk Drive For 8-bit Commodore 64/128, Tested, Working
$650.00
![Commodore Amiga 1000 + Keyboard + Mouse - NTSC - 512KB - WORKS 100% picture](/store/img/g/fPwAAOSwDwlmhGkq/s-l225/Commodore-Amiga-1000-Keyboard-Mouse-NTSC-512KB-WOR.jpg)
Commodore Amiga 1000 + Keyboard + Mouse - NTSC - 512KB - WORKS 100%
$599.99
![Vintage Commodore VIC 20 Computer Untested No Power Adapter For Parts/Repair picture](/store/img/g/BYMAAOSwbVhmhCYi/s-l225/Vintage-Commodore-VIC-20-Computer-Untested-No-Powe.jpg)
Vintage Commodore VIC 20 Computer Untested No Power Adapter For Parts/Repair
$64.87
![COMMODORE 64 COMPUTER 250407 HEATSINKS IC PLA TESTED/WORKING L#7 picture](/store/img/g/lBgAAOSwCjZmhB~n/s-l225/COMMODORE-64-COMPUTER-250407-HEATSINKS-IC-PLA-TEST.jpg)
COMMODORE 64 COMPUTER 250407 HEATSINKS IC PLA TESTED/WORKING L#7
$169.99