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

   Moving the database to Del.icio.us Add to del.icio.us
  Digg Moving the database Digg it
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: 8371
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: 8371
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 
Top Posters Last 30 Days
AllenAyres 20
Gizmo 10
blaaskaak 2
S7ARBVCK 2
Iann128 1
Claus1 1
M4D 1
Who's Online
0 Registered (), 35 Guests and 5 Spiders online.
Key: Admin, Global Mod, Mod
Shout Box

Latest Posts
Security Patch released for all 7.x versions
by AllenAyres
Yesterday at 08:00 PM
What do you use to edit the files
by AllenAyres
Yesterday at 07:54 PM
Team UBBDev Rides Again!
by AllenAyres
Yesterday at 07:32 PM
Here I am! Rock me like a Hurricane!
by AllenAyres
Yesterday at 07:20 PM
BeyondCompare v3.00
by AllenAyres
Yesterday at 07:16 PM
[7.3.1] add search to showmembers page
by AllenAyres
Yesterday at 07:13 PM
Noob - need help, or a reality check!
by Gizmo
09/04/08 03:21 AM
New Mods
[7.3.1] add search to showmembers page
by blaaskaak
Yesterday at 04:50 AM
Installing FlashChat with 7.3
by Paug
08/23/08 12:14 AM
[7.3.x] ubb.links
by AllenAyres
06/20/08 11:50 PM
[7.2.1] - Naked shoutbox
by sirdude
08/17/07 10:36 PM
[7.x] Generic Page Outside of forum directory
by
01/14/07 10:58 PM
Newest Members
veedubb8, twentyseven, Claus1, welcomeback1, Paug
13327 Registered Users

 

 

 
fusionbb message board php hacks