-
[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
![DEC Digital DECMATION D100Q Z80 processor card CP/M PDP-11 (1982) picture](/store/img/g/WKMAAOSwaStmfpqL/s-l225/DEC-Digital-DECMATION-D100Q-Z80-processor-card-CP-.jpg)
DEC Digital DECMATION D100Q Z80 processor card CP/M PDP-11 (1982)
$199.99
![Vintage Harris S550 Front Control Panel Console w/ Key, DEC PDP picture](/store/img/g/kd8AAOSw0itmAxUu/s-l225/Vintage-Harris-S550-Front-Control-Panel-Console-w-.jpg)
Vintage Harris S550 Front Control Panel Console w/ Key, DEC PDP
$2379.15
![*NEW UNOPENED* Vintage DEC LB-5923 Keyboard picture](/store/img/g/4hUAAOSwWCtmNpag/s-l225/-NEW-UNOPENED-Vintage-DEC-LB-5923-Keyboard.jpg)
*NEW UNOPENED* Vintage DEC LB-5923 Keyboard
$40.00
![Vintage DEC/The Redac mini cabinet front panel Digital Equipment Corp. 19](/store/img/g/Dg8AAOSwIsZkuslG/s-l225/Vintage-DEC-The-Redac-mini-cabinet-front-panel-Dig.jpg)
Vintage DEC/The Redac mini cabinet front panel Digital Equipment Corp. 19"
$269.99
![VINTAGE Green Screen Digital Terminal Monitor Model DEC VT320 - Powers On picture](/store/img/g/rQcAAOSwkRJmZ0mf/s-l225/VINTAGE-Green-Screen-Digital-Terminal-Monitor-Mode.jpg)
VINTAGE Green Screen Digital Terminal Monitor Model DEC VT320 - Powers On
$195.00
![Vintage DIGITAL DEC MICROVAX II - 630QZ-A2 picture](/store/img/g/EIgAAOSwY89mbGro/s-l225/Vintage-DIGITAL-DEC-MICROVAX-II-630QZ-A2.jpg)
Vintage DIGITAL DEC MICROVAX II - 630QZ-A2
$2000.00
![VINTAGE Digital Terminal Monitor Model DEC VT320 Powers On Black & White Screen picture](/store/img/g/79cAAOSwb69mZ0gO/s-l225/VINTAGE-Digital-Terminal-Monitor-Model-DEC-VT320-P.jpg)
VINTAGE Digital Terminal Monitor Model DEC VT320 Powers On Black & White Screen
$99.00
![Vintage DEC Digital Professional 350 Desktop Computer PC350-D2 picture](/store/img/g/6IUAAOSwRzhmeaIC/s-l225/Vintage-DEC-Digital-Professional-350-Desktop-Compu.jpg)
Vintage DEC Digital Professional 350 Desktop Computer PC350-D2
$1699.95
![VINTAGE DEC Digital RK11-D STATUS M7254 PDP 11 (B1) picture](/store/img/g/EIUAAOSwhFpmdXe5/s-l225/VINTAGE-DEC-Digital-RK11-D-STATUS-M7254-PDP-11-B1-.jpg)
VINTAGE DEC Digital RK11-D STATUS M7254 PDP 11 (B1)
$129.99
![VINTAGE DEC DIGITAL ELECTRONICS B2022-DA 128MB EDC MEMORY BOARD MODULE picture](/store/img/g/ePsAAOSwCTddYDbS/s-l225/VINTAGE-DEC-DIGITAL-ELECTRONICS-B2022-DA-128MB-EDC.jpg)
VINTAGE DEC DIGITAL ELECTRONICS B2022-DA 128MB EDC MEMORY BOARD MODULE
$37.00