php forum
php mysql forum
php mysql smarty
 
Topic Options
#203584 - 06/27/99 08:08 AM Moving the database
Flyin V Offline
Power User

Registered: 05/20/99
Posts: 73
I am a newbie so maybe the answer is easy or not possible.<br>I am going to be changing web servers soon. <br>Can I somehow download the mySQL database from my old server? <br>or do I have to start my forum over?<br><br>[ur] http://www.flyin.com/FPG/ [/url]
_________________________
www.clickteam.com

Top
#203585 - 06/27/99 09:05 AM Re: Moving the database [Re: Afx]
Rick Offline
Guru

Registered: 05/11/99
Posts: 8372
Loc: Olympia, WA
There is a command called [:yellow]mysqldump</font color=yellow> 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:<br><br>[:yellow]mysqldump WWWThreads > WWWThreads.backup</font color=yellow><br><br>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:<br><br>[:yellow]mysql WWWThreads < WWWThreads.backup</font color=yellow><br><br>---<br>Scream<br><A HREF="http://www.screamingweb.com">http://www.screamingweb.com</A>
_________________________
StogieSmokers.com

Top
#203586 - 06/30/99 01:42 PM Re: Moving the database [Re: Sally]
Flyin V Offline
Power User

Registered: 05/20/99
Posts: 73
I know you are not the mySQL support or a newbie trainer, but can you help me?<br>Got the database to download without a problem.<br>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.<br>Any words of wisdom you can share would be appreticated.<br><br><br><A HREF="http://www.flyin.com/FPG/">http://www.flyin.com/FPG/</A>
_________________________
www.clickteam.com

Top
#203587 - 07/01/99 09:52 AM Re: Moving the database [Re: Afx]
Rick Offline
Guru

Registered: 05/11/99
Posts: 8372
Loc: Olympia, WA
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?<br><br>---<br>Scream<br><A HREF="http://www.screamingweb.com">http://www.screamingweb.com</A>
_________________________
StogieSmokers.com

Top


Moderator:  Deb 
Who's Online
2 registered (AllenAyres, blaaskaak), 19 Guests and 11 Spiders online.
Key: Admin, Global Mod, Mod
Shout Box

Latest Posts
PhotoPost BB Code Popup
by AllenAyres
12/01/08 09:41 AM
Problems reading a lot of old posts here
by AllenAyres
12/01/08 09:35 AM
Forum 'Trader Ratings'.
by AllenAyres
12/01/08 09:33 AM
Spell Check [beta]
by AllenAyres
12/01/08 09:32 AM
Customization needed
by Gizmo
11/12/08 12:28 PM
Team UBBDev Rides Again!
by AllenAyres
11/11/08 02:16 PM
Active Topics.
by AllenAyres
11/11/08 02:13 PM
New Mods
User Authentication Class
by
01/19/07 02:59 PM
Multiple Identity Detector
by
12/30/06 06:39 PM
PhotoPost BB Code Popup
by
11/06/06 05:43 PM
Spell Check [beta]
by
10/17/06 09:24 PM
Newest Members
David DelMonte, nick1, Begbie, cenk, MATTO
13363 Registered Users
Top Posters
AllenAyres 25449
JoshPet 11330
Rick 8372
LK 7396
Lord Dexter 6503
Greg Hard 5533
Charles Capps 5438

 

 

 
fusionbb message board php hacks