-
[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
![HP Workstation Z640 2x Xeon E5-2623V3 32GB Ram 2x256GB SSD Quadro K420 NO OS GA picture](/store/img/rIQAAOSwN9Nlnw4a/s-l225//HP-Workstation-Z640-2x-Xeon-E5-2623V3-32GB-Ram-2x2.jpg)
HP Workstation Z640 2x Xeon E5-2623V3 32GB Ram 2x256GB SSD Quadro K420 NO OS GA
$154.98
![Dell Precision 5810 Workstation Xeon E5-1650 6C 3.5GHz 16GB 500GB Win10 K2200 picture](/store/img/60cAAOSwEIll-JnV/s-l225//Dell-Precision-5810-Workstation-Xeon-E5-1650-6C-3-.jpg)
Dell Precision 5810 Workstation Xeon E5-1650 6C 3.5GHz 16GB 500GB Win10 K2200
$124.67
![Intel Xeon E-2286G (SRF7C) 6-Core GHz 12 MB LGA 1151 CPU/Processor picture](/store/img/k5kAAOSw~5dmmvpO/s-l225//Intel-Xeon-E-2286G-SRF7C-6-Core-GHz-12-MB-LGA-1151.jpg)
Intel Xeon E-2286G (SRF7C) 6-Core GHz 12 MB LGA 1151 CPU/Processor
$297.00
![HP Z440 Workstation 18Cores Xeon E5-2699 V3 128GB 1TB SSD 2TB WIFI WIN11 R5-340X picture](/store/img/itIAAOSwjT9mKCN6/s-l225//HP-Z440-Workstation-18Cores-Xeon-E5-2699-V3-128GB-.jpg)
HP Z440 Workstation 18Cores Xeon E5-2699 V3 128GB 1TB SSD 2TB WIFI WIN11 R5-340X
$309.99
![Intel Xeon E5-2680 V4 CPU 2.4~3.3GHz 14-Core 35M LGA 2011-3 R3 Server SR2N7 120W picture](/store/img/hLcAAOSwA81iMQ7h/s-l225//Intel-Xeon-E5-2680-V4-CPU-2-4-3-3GHz-14-Core-35M-L.jpg)
Intel Xeon E5-2680 V4 CPU 2.4~3.3GHz 14-Core 35M LGA 2011-3 R3 Server SR2N7 120W
$15.99
![Intel Xeon E5-2680 V3 2.50Ghz 12 Core 30MB Cache LGA 2011-3 CPU SR1XP Tested picture](/store/img/M1EAAOSwdAdjG8AH/s-l225//Intel-Xeon-E5-2680-V3-2-50Ghz-12-Core-30MB-Cache-L.jpg)
Intel Xeon E5-2680 V3 2.50Ghz 12 Core 30MB Cache LGA 2011-3 CPU SR1XP Tested
$5.90
![Intel Xeon Gold 6138 2.0GHz 27.5MB 20-Core 125W LGA3647 SR3B5 picture](/store/img/U4wAAOSw~HJka8-T/s-l225//Intel-Xeon-Gold-6138-2-0GHz-27-5MB-20-Core-125W-LG.jpg)
Intel Xeon Gold 6138 2.0GHz 27.5MB 20-Core 125W LGA3647 SR3B5
$37.00
![Matched Pair Intel Xeon E5-2680 v2 10-Core 2.80GHz 25MB LGA2011 SR1A6 picture](/store/img/PfwAAOSwm95mego4/s-l225//Matched-Pair-Intel-Xeon-E5-2680-v2-10-Core-2-80GHz.jpg)
Matched Pair Intel Xeon E5-2680 v2 10-Core 2.80GHz 25MB LGA2011 SR1A6
$13.99
![Intel Xeon Platinum 8168 SR37J 24-Core 48-Thread 2.70GHz 33MB Cache LGA3647-205W picture](/store/img/B1gAAOSw9i5mavdx/s-l225//Intel-Xeon-Platinum-8168-SR37J-24-Core-48-Thread-2.jpg)
Intel Xeon Platinum 8168 SR37J 24-Core 48-Thread 2.70GHz 33MB Cache LGA3647-205W
$279.99
![Intel Xeon E5-2695 V4 2.10 GHz 18-Core SR2J1 LGA2011-3 CPU Processor 2695V4 picture](/store/img/1XsAAOSwEVFl-Z9k/s-l225//Intel-Xeon-E5-2695-V4-2-10-GHz-18-Core-SR2J1-LGA20.jpg)
Intel Xeon E5-2695 V4 2.10 GHz 18-Core SR2J1 LGA2011-3 CPU Processor 2695V4
$29.87