-
[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
![TP-Link 24-Port Gigabit Ethernet Unmanaged Switch Desktop/Rackmount TL-SG1024D picture](/store/img/g/rvkAAOSwZBBi5CPU/s-l225/TP-Link-24-Port-Gigabit-Ethernet-Unmanaged-Switch-.jpg)
TP-Link 24-Port Gigabit Ethernet Unmanaged Switch Desktop/Rackmount TL-SG1024D
$69.99
![CISCO MERAKI MS120-24P-HW 24-PORT GIGABIT CLOUD MANAGED PoE SWITCH - UNCLAIMED picture](/store/img/g/uj4AAOSw8hhmYQRm/s-l225/CISCO-MERAKI-MS120-24P-HW-24-PORT-GIGABIT-CLOUD-MA.jpg)
CISCO MERAKI MS120-24P-HW 24-PORT GIGABIT CLOUD MANAGED PoE SWITCH - UNCLAIMED
$98.55
![New In Box BNIB Cisco SG300-10 - 10-Port Ethernet Gigabit Managed Switch S23 picture](/store/img/g/0MsAAOSwS1JmG~B5/s-l225/New-In-Box-BNIB-Cisco-SG300-10-10-Port-Ethernet-Gi.jpg)
New In Box BNIB Cisco SG300-10 - 10-Port Ethernet Gigabit Managed Switch S23
$119.99
![Loocam Gigabit PoE Switch 8 Port 96W 2 Uplink Port Unmanaged Ethernet Switch picture](/store/img/g/BUMAAOSwtOFjdfzi/s-l225/Loocam-Gigabit-PoE-Switch-8-Port-96W-2-Uplink-Port.jpg)
Loocam Gigabit PoE Switch 8 Port 96W 2 Uplink Port Unmanaged Ethernet Switch
$49.99
![NETGEAR GS108 ProSafe 8-Port GbE Unmanaged Switch w/ Power Adapter picture](/store/img/g/GtAAAOSw441l3Jx1/s-l225/NETGEAR-GS108-ProSafe-8-Port-GbE-Unmanaged-Switch-.jpg)
NETGEAR GS108 ProSafe 8-Port GbE Unmanaged Switch w/ Power Adapter
$14.99
![Dell X1052P Series 52-Port Gigabit Rack Mountable Managed Network Switch picture](/store/img/g/IjQAAOSwqrVmUJen/s-l225/Dell-X1052P-Series-52-Port-Gigabit-Rack-Mountable-.jpg)
Dell X1052P Series 52-Port Gigabit Rack Mountable Managed Network Switch
$30.00
![HP ProCurve J9772A 2530-48G POE 48 Port Gigabit Ethernet Switch 4x SFP picture](/store/img/g/PPEAAOSwvDplCIsh/s-l225/HP-ProCurve-J9772A-2530-48G-POE-48-Port-Gigabit-Et.jpg)
HP ProCurve J9772A 2530-48G POE 48 Port Gigabit Ethernet Switch 4x SFP
$55.00
![Cisco WS-C2960S-48TS-L 48 Port Gigabit Ethernet LAN Switch - Same Day Shipping picture](/store/img/g/pVEAAOSwkjpjh8my/s-l225/Cisco-WS-C2960S-48TS-L-48-Port-Gigabit-Ethernet-LA.jpg)
Cisco WS-C2960S-48TS-L 48 Port Gigabit Ethernet LAN Switch - Same Day Shipping
$29.99
![Dell X1018 X-Series Smart Managed Switches 16-Port Gigabit 2-Port SFP Switch picture](/store/img/g/-yUAAOSw-JVlyRj9/s-l225/Dell-X1018-X-Series-Smart-Managed-Switches-16-Port.jpg)
Dell X1018 X-Series Smart Managed Switches 16-Port Gigabit 2-Port SFP Switch
$42.00
![Fortinet FortiSwitch FS-124D-POE 24 Port Gigabit Ethernet Switch UNREGISTERED picture](/store/img/g/kjQAAOSwNkhj0o7Y/s-l225/Fortinet-FortiSwitch-FS-124D-POE-24-Port-Gigabit-E.jpg)
Fortinet FortiSwitch FS-124D-POE 24 Port Gigabit Ethernet Switch UNREGISTERED
$99.97