-
[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
![Intel Core i7-13700KF - 13th Gen Raptor Lake 16-Core (8P+8E) Desktop CPU Proc... picture](/store/img/g/jHUAAOSwQ5RmYLmZ/s-l225/Intel-Core-i7-13700KF-13th-Gen-Raptor-Lake-16-Core.jpg)
Intel Core i7-13700KF - 13th Gen Raptor Lake 16-Core (8P+8E) Desktop CPU Proc...
$269.99
![AMD Ryzen 9 7900X3D Gaming Processor - 12 Core And 24 Threads picture](/store/img/g/lUEAAOSw4exmMBDH/s-l225/AMD-Ryzen-9-7900X3D-Gaming-Processor-12-Core-And-2.jpg)
AMD Ryzen 9 7900X3D Gaming Processor - 12 Core And 24 Threads
$309.99
![Intel - Core i7-12700K Desktop Processor 12 (8P+4E) Cores up to 5.0 GHz Unloc... picture](/store/img/g/7-YAAOSwHaFjXQ2k/s-l225/Intel-Core-i7-12700K-Desktop-Processor-12-8P-4E-Co.jpg)
Intel - Core i7-12700K Desktop Processor 12 (8P+4E) Cores up to 5.0 GHz Unloc...
$214.99
![Intel Core i5-11400F 2.6GHz 6-Core Desktop Processor, LGA 1200 Socket picture](/store/img/g/U6cAAOSwgVNmiHOu/s-l225/Intel-Core-i5-11400F-2-6GHz-6-Core-Desktop-Process.jpg)
Intel Core i5-11400F 2.6GHz 6-Core Desktop Processor, LGA 1200 Socket
$60.00
![Intel - Core i9-12900K Desktop Processor 16 (8P+8E) Cores up to 5.2 GHz Unloc... picture](/store/img/g/snwAAOSwhWZhsOrI/s-l225/Intel-Core-i9-12900K-Desktop-Processor-16-8P-8E-Co.jpg)
Intel - Core i9-12900K Desktop Processor 16 (8P+8E) Cores up to 5.2 GHz Unloc...
$309.99
![Intel - Core i5-12600K Desktop Processor 10 (6P+4E) Cores up to 4.9 GHz Unloc... picture](/store/img/g/l40AAOSwi61hsOsH/s-l225/Intel-Core-i5-12600K-Desktop-Processor-10-6P-4E-Co.jpg)
Intel - Core i5-12600K Desktop Processor 10 (6P+4E) Cores up to 4.9 GHz Unloc...
$174.99
![AMD Ryzen 5 7600x Processor (5.3 GHz, 6 Cores, LGA 1718/Socket AM5) NEW OEM Tray picture](/store/img/g/TPkAAOSwvv5mT7XN/s-l225/AMD-Ryzen-5-7600x-Processor-5-3-GHz-6-Cores-LGA-17.jpg)
AMD Ryzen 5 7600x Processor (5.3 GHz, 6 Cores, LGA 1718/Socket AM5) NEW OEM Tray
$179.99
![Intel Core i5-8400 Six Core 2.80 GHz LGA 1151 Desktop PC CPU Processor SR3QT picture](/store/img/g/9WwAAOSwAC5mfx-y/s-l225/Intel-Core-i5-8400-Six-Core-2-80-GHz-LGA-1151-Desk.jpg)
Intel Core i5-8400 Six Core 2.80 GHz LGA 1151 Desktop PC CPU Processor SR3QT
$40.99
![LOT QTY 2 of INTEL XEON 10 CORE E5-2690 V2 25MB 3.00GHZ CPU SR1A5 picture](/store/img/g/NLUAAOSwSoBkpZ7y/s-l225/LOT-QTY-2-of-INTEL-XEON-10-CORE-E5-2690-V2-25MB-3-.jpg)
LOT QTY 2 of INTEL XEON 10 CORE E5-2690 V2 25MB 3.00GHZ CPU SR1A5
$139.99
![Wholesale AMD Ryzen r5-2600x CPU Processor lot picture](/store/img/g/d8IAAOSwXy9mhOs1/s-l225/Wholesale-AMD-Ryzen-r5-2600x-CPU-Processor-lot.jpg)
Wholesale AMD Ryzen r5-2600x CPU Processor lot
$382.77