Previous Thread
Next Thread
Print Thread
Rate Thread
#203584 06/27/1999 8:08 AM
Joined: May 1999
Posts: 41
Power User
Power User
Offline
Joined: May 1999
Posts: 41
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]

Sponsored Links
Afx #203585 06/27/1999 9:05 AM
Joined: May 1999
Posts: 3,039
Guru
Guru
Offline
Joined: May 1999
Posts: 3,039
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


UBB.threads Developer
Joined: May 1999
Posts: 41
Power User
Power User
Offline
Joined: May 1999
Posts: 41
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/

Afx #203587 07/01/1999 9:52 AM
Joined: May 1999
Posts: 3,039
Guru
Guru
Offline
Joined: May 1999
Posts: 3,039
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.threads Developer

Link Copied to Clipboard
Donate Today!
Donate via PayPal

Donate to UBBDev today to help aid in Operational, Server and Script Maintenance, and Development costs.

Please also see our parent organization VNC Web Services if you're in the need of a new UBB.threads Install or Upgrade, Site/Server Migrations, or Security and Coding Services.
Recommended Hosts
We have personally worked with and recommend the following Web Hosts:
Stable Host
bluehost
InterServer
Visit us on Facebook
Member Spotlight
isaac
isaac
California
Posts: 1,157
Joined: July 2001
Forum Statistics
Forums63
Topics37,573
Posts293,925
Members13,849
Most Online5,166
Sep 15th, 2019
Today's Statistics
Currently Online
Topics Created
Posts Made
Users Online
Birthdays
Top Posters
AllenAyres 21,079
JoshPet 10,369
LK 7,394
Lord Dexter 6,708
Gizmo 5,833
Greg Hard 4,625
Top Posters(30 Days)
Top Likes Received
isaac 82
Gizmo 20
Brett 7
WebGuy 2
Top Likes Received (30 Days)
None yet
The UBB.Developers Network (UBB.Dev/Threads.Dev) is ©2000-2024 VNC Web Services

 
Powered by UBB.threads™ PHP Forum Software 8.0.0
(Preview build 20221218)