-
[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
![Dell OptiPlex 3060 MICRO DESKTOP PC COMPUTER I5 8TH GEN UP TO 32GB UP TO 2TB M.2 picture](/store/img/g/2mYAAOSwmulmdXzA/s-l225/Dell-OptiPlex-3060-MICRO-DESKTOP-PC-COMPUTER-I5-8T.jpg)
Dell OptiPlex 3060 MICRO DESKTOP PC COMPUTER I5 8TH GEN UP TO 32GB UP TO 2TB M.2
$295.00
![Apple 2019 Mac Pro 28-Core Xeon W-3275M 96GB RAM 1TB SSD Radeon Pro 580X 8GB picture](/store/img/g/g9wAAOSwtb5mMUYG/s-l225/Apple-2019-Mac-Pro-28-Core-Xeon-W-3275M-96GB-RAM-1.jpg)
Apple 2019 Mac Pro 28-Core Xeon W-3275M 96GB RAM 1TB SSD Radeon Pro 580X 8GB
$2999.97
![Dell 15.6](/store/img/g/9x4AAOSwVAlmICu5/s-l225/Dell-15-6-NVIDIA-Gaming-Laptop-Intel-Quad-Core-i7-.jpg)
Dell 15.6" NVIDIA Gaming Laptop - Intel Quad Core i7 64GB RAM 2TB SSD Windows 11
$446.00
![New HP 24](/store/img/g/TWcAAOSw2QlmXTVp/s-l225/New-HP-24-All-In-One-Desktop-Computer-11th-Gen-i3-.jpg)
New HP 24" All In One Desktop Computer 11th Gen i3 Up To 32GB RAM 2TB SSD Win 11
$409.99
![Intel Core i7-3770 SR0PK 3.40GHz Quad Core LGA1155 8MB Processor CPU picture](/store/img/g/JZoAAOSwPrdmgvpQ/s-l225/Intel-Core-i7-3770-SR0PK-3-40GHz-Quad-Core-LGA1155.jpg)
Intel Core i7-3770 SR0PK 3.40GHz Quad Core LGA1155 8MB Processor CPU
$26.99
![AMD Ryzen 7 7800X3D 8-Core - 16-Thread 4.2 GHz (5.0 GHz Max Boost) Socket A... picture](/store/img/g/3isAAOSw~lNmI3aE/s-l225/AMD-Ryzen-7-7800X3D-8-Core-16-Thread-4-2-GHz-5-0-G.jpg)
AMD Ryzen 7 7800X3D 8-Core - 16-Thread 4.2 GHz (5.0 GHz Max Boost) Socket A...
$304.95
![AMD FX-8350 4.0GHz 8-Core CPU Processor FD8350FRW8KHK Socket AM3+ picture](/store/img/g/cnkAAOSwfAxmfw-e/s-l225/AMD-FX-8350-4-0GHz-8-Core-CPU-Processor-FD8350FRW8.jpg)
AMD FX-8350 4.0GHz 8-Core CPU Processor FD8350FRW8KHK Socket AM3+
$50.00
![Dell Inspiron 142-in-1 Touch Laptop Intel Core 5 Processor 8GB Memory... picture](/store/img/g/sSgAAOSwm3JmUI62/s-l225/Dell-Inspiron-142-in-1-Touch-Laptop-Intel-Core-5-P.jpg)
Dell Inspiron 142-in-1 Touch Laptop Intel Core 5 Processor 8GB Memory...
$749.99
![Dell 5500 15.6](/store/img/g/tzcAAOSwQCJmIUYZ/s-l225/Dell-5500-15-6-Touch-Light-Gaming-Laptop-Intel-Cor.jpg)
Dell 5500 15.6" Touch Light Gaming Laptop Intel Core i5 4.10GHz 64GB RAM 2TB SSD
$344.00
![Lenovo IdeaCentre 3 07IRB8 Desktop Intel Core i5-13400 16GB 512GB SSD W11H picture](/store/img/g/1UcAAOSwYS9lXgtq/s-l225/Lenovo-IdeaCentre-3-07IRB8-Desktop-Intel-Core-i5-1.jpg)
Lenovo IdeaCentre 3 07IRB8 Desktop Intel Core i5-13400 16GB 512GB SSD W11H
$349.99