UBB.Dev
Posted By: Flyin V Moving the database - 06/27/1999 3:08 PM
I am a newbie so maybe the answer is easy or not possible.
I am going to be changing web servers soon.
Can I somehow download the mySQL database from my old server?
or do I have to start my forum over?

[ur] http://www.flyin.com/FPG/ [/url]
Posted By: Rick Re: Moving the database - 06/27/1999 4:05 PM
There is a command called [:yellow]mysqldump that will dump out your existing database. So if you have access to it, you can use that. For instance, if your database name is WWWThreads, you would use the following command to dump out the database to a file called WWWThreads.backup:

[:yellow]mysqldump WWWThreads > WWWThreads.backup

Then when you get on the new server and have created your database you would run the following command to feed your tables and data into the new database:

[:yellow]mysql WWWThreads < WWWThreads.backup

---
Scream
http://www.screamingweb.com
Posted By: Flyin V Re: Moving the database - 06/30/1999 8:42 PM
I know you are not the mySQL support or a newbie trainer, but can you help me?
Got the database to download without a problem.
When I try to upload how do I set my user name and password at the telnet prompt? If I sign into the mySQL prompt do I use the syntax as above? or something else. I could not get this to work.
Any words of wisdom you can share would be appreticated.


http://www.flyin.com/FPG/
Posted By: Rick Re: Moving the database - 07/01/1999 4:52 PM
Well, normally the way I do it is login with telnet as normal and then I feed the database into SQL database. Do you have normal telnet access?

---
Scream
http://www.screamingweb.com
© UBB.Developers