Databases :: MySql :: backup and restore one of mysql database |
|||
By: Squibi  |
Date: 30/05/2003 00:00:00  |
Points: 50 | Status: Answered Quality : Excellent |
|
Dear experts, I will change the hosting company. Could any suggest me how to backup my current mysql database and restore to the new hosting company? Thanks a lot! |
|||
| By: VGR | Date: 30/05/2003 03:06:00 | |
Type : Comment |
| do you have some console access ? Then do a mysqldump or do you have a web admin program ? Then try to find mysqldump or : describe tablename; -> save to file and you've your layout select * from tablename into outfile tablename.txt; -> then FTP or get back tablename.txt and you've your data or pray :D |
|||
| By: VGR | Date: 30/05/2003 03:07:00 | |
Type : Comment |
| between "or" and "pray", you can also add : -uild a PHP script doing the above operatioons for all tables of all the databases add also the possibility : -ask the current provider to send you the MySql data files : MYD, MYI and FRM After all, they are yours 8-) |
|||
| By: Squibi | Date: 30/05/2003 03:45:00 | |
Type : Comment |
| Hi VGR, Actually, the provider had given me the MYD, MYI and FRM files. But how can I use those file to restore the DB? |
|||
| By: MaxWonderful | Date: 30/05/2003 04:16:00 | |
Type : Comment |
| Hello , Is your hosting company actually running the MySQL database server you are using for your database, or is your website pointing to your own MySQL databaser server? |
|||
| By: VGR | Date: 30/05/2003 04:20:00 | |
Type : Answer |
| LUCKY YOU ARE !!! ok : this is what you need to do to restore locally or remotely the DB (provided the platform is compatible, as it is 99% of the time) 1) recreate the structure of the DB (CREATE DATABASE... CREATE TABLE... etc) 2) stop the server 3) trash/move the MYD, MYI and FRM files you'll find in datadir/thedatabasename 4) put in there the files given to you by your previous provider (lucky you are, one more time 8-) 5) restart server 6) enjoy the power of MySql |
|||
| By: wildfrag | Date: 04/06/2003 18:22:00 | |
Type : Comment |
| try to use MySQL Snap <A HREF="http://www.php-art.com/products.php">http://www.php-art.com/products.php</a> Very fast and robust mysql dump/recovery tool |
|||
|
Do register to be able to answer |
|||
©2010 These pages are served without commercial sponsorship. (No popup ads, etc...). Bandwidth abuse increases hosting cost forcing sponsorship or shutdown. This server aggressively defends against automated copying for any reason including offline viewing, duplication, etc... Please respect this requirement and DO NOT RIP THIS SITE.
Please DO link to this page!
Contact
- Privacy
- Contact us
- Member Agreement
- Jobs for our Experts
- our friend ActuLab
- Carcasherdotcom Seocontest
- Add Your Link
- Bee Web Directory
- Discover Directory
- FFind Directory
- Link Velocity Directory
- The Little Web Directory
- Red Links
- Tranix
- 2space Global Directory
Fully downloaded more than 1313 Million times
Copyright © 2003 - 2012 The IT European Experts Organization
last update on : 23/07/2008 09:41:27 GMT 0 (CEST)
