Jump to content

Question On Moving A Database


Recommended Posts

is it possible to move a mysql database intact?

or am I going to have to reinstall and reset up everything?


Or if I have to reset things up is it possible to move the "tables" ?

I have a back up of the database from my previous server can I use the back up?


I am not looking forward to redoing my almost 1000 tables

Link to comment
Share on other sites

If you have some method of dumping the database - either phpmyadmin, command line or some other system, then you can just import it here using phpmyadmin. If it is very large you could also ftp the export file to your server then submit a ticket and ask them to import it locally so that there are no timeouts. If you do that you'd need to include the name of the file, the directory, and the name of the database to be imported to - and have setup the database here (via cpanel).


I've done this a few times successfully, although I did my own imports as my databases were all under 6meg.


does that help?

Link to comment
Share on other sites

If your other host has cpanel, you may be able to move your entire site here with a help ticket. this will include files, databases and e-mail.


How did you make the database backup

phpMyadmin or cpanel>backup ?


If cpanel > backup, you can upload the same way.

If phpMyadmin export, you can create the database

in MySql and import the back up in phpMyadmin, located at the bottom of the MySql page in cpanel.

click on data base > SQL > browse to file below the

Or Location of the textfile : text.

Link to comment
Share on other sites

ok thanks, my hubbie asked my why I didn't just go thru the phpmyadmin and get the database stucture.......I was like duh....... so going to try that..........and if that doesn't work will try the help ticket thingie.


Thanks for the ideas I guess trying to work on this til 3 am has really frazzled my brain..



Hopefully I can change the "name and users" for the database.......

Link to comment
Share on other sites

yep yep *dances* got it to work.......wwwwwhhhhhheeeeeeeeeeeee 4 weeks of frustration will finally come to an end I do hope.


I was able to use my site backup from the other cpanel uploaded it to the TCH server and then moved the folder I wanted to the public_html . Now I can just get the stuff I want off the old back up and then get rid of the old back up.


Thank you so much for the help at my dark hour of almost a nervous breakdown when I thought of all the folders I was going to have to redo....(almost 1000 give or take a few)..

Link to comment
Share on other sites

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.


  • Create New...