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: 8373
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>
_________________________
UBB.threads Developer

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: 8373
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>
_________________________
UBB.threads Developer

Top



Moderator:  Deb 
Latest Posts
[7.2.1] - Naked shoutbox
by bellaonline
05/05/12 05:00 PM
[7.x] Stop Forum Spam Integration v0.4
by bellaonline
05/05/12 03:53 PM
Shout Box

(Views)Popular Topics
Known public proxy servers 1689885
Integrated Index Page (IIP) 5.3.1 555705
Finished-[6.5.2] Games Arcade Deluxe v1.9 501236
Integrated Index Page (IIP) 5.1.1 415112
TLD Bv2.1 Released - Threads Links Directory 396822
[6.0x] Who's Online 4.0.0 [Finished] 389412
Finished-[6.5.1] Integrated Index Page (IIP) 6.5 330423
Q & A 298663
Slash UBB 266936
[6.3.x] [beta] Hit Hack 2.0 227970
Forum Stats
13621 Members
59 Forums
37191 Topics
295716 Posts

Max Online: 686 @ 06/28/07 07:04 AM

 

 

 
fusionbb message board php hacks