-
[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
![Grandstream GS-HT802 2 Port Analog Telephone Adapter VoIP Phone & Device, Black picture](/store/img/g/cEQAAOSwKIlgze4p/s-l225/Grandstream-GS-HT802-2-Port-Analog-Telephone-Adapt.jpg)
Grandstream GS-HT802 2 Port Analog Telephone Adapter VoIP Phone & Device, Black
$32.00
![Polycom VVX 411 IP VOIP POE Gigabit Telephone [L/N] BUSINESS OFFICE RECEPTION picture](/store/img/g/PZoAAOSwM3xmZJQs/s-l225/Polycom-VVX-411-IP-VOIP-POE-Gigabit-Telephone-L-N-.jpg)
Polycom VVX 411 IP VOIP POE Gigabit Telephone [L/N] BUSINESS OFFICE RECEPTION
$24.00
![Cisco 7962 Series CP-7962G Unified VoIP IP Business Phone picture](/store/img/g/igoAAOSw0rhlFY7v/s-l225/Cisco-7962-Series-CP-7962G-Unified-VoIP-IP-Busines.jpg)
Cisco 7962 Series CP-7962G Unified VoIP IP Business Phone
$6.99
![Grandstream WP820 Portable Wi-Fi Phone Voip Phone Device Rechargeable 1500Mah picture](/store/img/g/EbcAAOSwoOtmhAcz/s-l225/Grandstream-WP820-Portable-Wi-Fi-Phone-Voip-Phone-.jpg)
Grandstream WP820 Portable Wi-Fi Phone Voip Phone Device Rechargeable 1500Mah
$92.99
![Cisco CP-7945G VOIP Phone With Stand & Handset Business IP Phone 7945 picture](/store/img/g/NjUAAOSwEmNmEw4x/s-l225/Cisco-CP-7945G-VOIP-Phone-With-Stand-Handset-Busin.jpg)
Cisco CP-7945G VOIP Phone With Stand & Handset Business IP Phone 7945
$3.00
![New Cisco 7945G IP VoIP Gigabit GIGE Telephone Phone CP-7945G - picture](/store/img/g/ky0AAOSwk4RmDzQo/s-l225/New-Cisco-7945G-IP-VoIP-Gigabit-GIGE-Telephone-Pho.jpg)
New Cisco 7945G IP VoIP Gigabit GIGE Telephone Phone CP-7945G -
$24.95
![Obihai OBI200 1-Port VoIP Phone Adapter picture](/store/img/g/6ewAAOSwUDxmhIj2/s-l225/Obihai-OBI200-1-Port-VoIP-Phone-Adapter.jpg)
Obihai OBI200 1-Port VoIP Phone Adapter
$40.00
![Yealink SIP-T54W 16-Line Color Display Business VoIP Phone /w Built-in Bluetooth picture](/store/img/g/Nh0AAOSwj0dmWNA9/s-l225/Yealink-SIP-T54W-16-Line-Color-Display-Business-Vo.jpg)
Yealink SIP-T54W 16-Line Color Display Business VoIP Phone /w Built-in Bluetooth
$50.99
![Lot Of 7 Cisco CP-7945G VOIP Phone With Stand & Handset Business IP Phone 7945 picture](/store/img/g/b7wAAOSwzeFjaUbX/s-l225/Lot-Of-7-Cisco-CP-7945G-VOIP-Phone-With-Stand-Hand.jpg)
Lot Of 7 Cisco CP-7945G VOIP Phone With Stand & Handset Business IP Phone 7945
$41.99
![Polycom VVX 250 Business IP Phone with 2.8 in. Color Display & Ethernet, Black picture](/store/img/g/AWgAAOSwFuZmTXtC/s-l225/Polycom-VVX-250-Business-IP-Phone-with-2-8-in-Colo.jpg)
Polycom VVX 250 Business IP Phone with 2.8 in. Color Display & Ethernet, Black
$44.99