-
[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
![ORICO 5 Bay Raid Enclosure USB3.0 SATA External Hard Drive Enclosure Up to 80TB picture](/store/img/g/m2IAAOSwmz5kyNFT/s-l225/ORICO-5-Bay-Raid-Enclosure-USB3-0-SATA-External-Ha.jpg)
ORICO 5 Bay Raid Enclosure USB3.0 SATA External Hard Drive Enclosure Up to 80TB
$115.59
![Dell EMC 092GD6 Broadcom 9305-16i LSI Quad Port 4 Port SAS RAID Controller picture](/store/img/g/ph8AAOSwnHxmXzcB/s-l225/Dell-EMC-092GD6-Broadcom-9305-16i-LSI-Quad-Port-4-.jpg)
Dell EMC 092GD6 Broadcom 9305-16i LSI Quad Port 4 Port SAS RAID Controller
$84.99
![Oracle MegaRAID SAS9361-16i 16-Port 12Gb/s PCIe SAS RAID Controller P/N: 7332895 picture](/store/img/g/JmUAAOSwCxVmfwju/s-l225/Oracle-MegaRAID-SAS9361-16i-16-Port-12Gb-s-PCIe-SA.jpg)
Oracle MegaRAID SAS9361-16i 16-Port 12Gb/s PCIe SAS RAID Controller P/N: 7332895
$149.99
![ORICO 5 Bay Raid USB3.0 to SATA External Hard Drive Enclosure for 3.5'' HDD LOT picture](/store/img/g/m2IAAOSwmz5kyNFT/s-l225/ORICO-5-Bay-Raid-USB3-0-to-SATA-External-Hard-Driv.jpg)
ORICO 5 Bay Raid USB3.0 to SATA External Hard Drive Enclosure for 3.5'' HDD LOT
$140.79
![ASUS Hyper M.2 x16 Gen 4 RAID Card- Used Working picture](/store/img/g/fGwAAOSwAStmfi9c/s-l225/ASUS-Hyper-M-2-x16-Gen-4-RAID-Card-Used-Working.jpg)
ASUS Hyper M.2 x16 Gen 4 RAID Card- Used Working
$32.95
![Dell PERC H330 PCIe 3.0 x8 RAID Storage Controller 4Y5H1 High Profile picture](/store/img/g/C7YAAOSwLYJl3nQQ/s-l225/Dell-PERC-H330-PCIe-3-0-x8-RAID-Storage-Controller.jpg)
Dell PERC H330 PCIe 3.0 x8 RAID Storage Controller 4Y5H1 High Profile
$17.99
![Intel RS25DB080 1GB 8-Port 6Gbps PCIe SAS/SATA RAID Controller Card picture](/store/img/g/qmEAAOSwjcpmiD-z/s-l225/Intel-RS25DB080-1GB-8-Port-6Gbps-PCIe-SAS-SATA-RAI.jpg)
Intel RS25DB080 1GB 8-Port 6Gbps PCIe SAS/SATA RAID Controller Card
$20.00
![ACASIS 2.5/3.5 inch 2 Bay SATA USB 3.0 Hard Drive Disk HDD SSD Enclosure 4 RAID picture](/store/img/g/VpUAAOSweWVlEXFE/s-l225/ACASIS-2-5-3-5-inch-2-Bay-SATA-USB-3-0-Hard-Drive-.jpg)
ACASIS 2.5/3.5 inch 2 Bay SATA USB 3.0 Hard Drive Disk HDD SSD Enclosure 4 RAID
$54.66
![OWC Guardian Maximus Raid Enclosure SATA Hard Drive FireWire picture](/store/img/g/-FoAAOSwtEBmQ5qa/s-l225/OWC-Guardian-Maximus-Raid-Enclosure-SATA-Hard-Driv.jpg)
OWC Guardian Maximus Raid Enclosure SATA Hard Drive FireWire
$36.99
![8 Bay Tool Less Tray Hot Swap 2.5](/store/img/g/3qgAAOSwoa9mfrgW/s-l225/8-Bay-Tool-Less-Tray-Hot-Swap-2-5-3-5-SATA-Non-RAI.jpg)
8 Bay Tool Less Tray Hot Swap 2.5" 3.5" SATA Non RAID Ext USB 3.0 Enclosure USED
$150.00