User Name
Password
AppleNova Forums » General Discussion »

Anybody out there familiar with MySQL commands?


Register Members List Calendar Search FAQ Posting Guidelines
Anybody out there familiar with MySQL commands?
Thread Tools
LoCash
Rest In Peace
 
Join Date: May 2004
Location: Atlanta
 
2004-07-06, 17:15

I need two commands, and I really don't feel like conquering the manual right now.

I need the command to dump an entire database out to a .sql file. Then I need the command to write that dump back into a database. Basically, I need to take the live AppleNova database for the forums and write it into the non-production server's database so I have data to play with there.

First person to hook me up wins a cookie. It might have teh whipped cream.

It is with great regret that we say our farewells to Jack, who passed away on May 28th, 2005. Jack, you will be missed by all

Superior thinking has always overwhelmed superior force. - Marine Corps Officers

"You don't lead by hitting people over the head-that's assault, not leadership." - General Eisenhower
  quote
HOM
The Elder™
 
Join Date: May 2004
Location: The Rostra
 
2004-07-06, 17:58

Telnet in and find the MySQL programs directory (usually /usr/local/mysql/bin )
Run this command:

Code:
mysqldump <dbname> > /forum.sql
Where <dbname> is the name of the database of vBulletin.

You should then transfer this forum.sql file onto the new server.

Find the MySQL programs directory through Telnet on the new server.

Run this command:

Code:
mysqladmin create <dbname> mysql <dbname> /forum.sql
This post was completly ripped of from this page. None of this content is mine at all and I take no responsibility for the results.

Hell I don't even know what it means. Now where are my whippets?

CARTHAGO DELENDA EST

¡Viva La Revolucion!
  quote
SilentEchoes
Unique Like Everyone Else
 
Join Date: May 2004
Location: Rochester, NY
Send a message via AIM to SilentEchoes  
2004-07-06, 18:42

Yeah those commands will do it. You will need to login as the appropriate user though by issuing the -u <username> flag and -p flag for password
  quote
Brad
Selfish Heathen
 
Join Date: May 2004
Location: Zone of Pain
 
2004-07-06, 19:20

LoCash, aren't you the one that told me just to use phpMyAdmin for AppleNova DB issues? For the terminal- or manual-phobic, there's a simple "export" option with a number of easy-to-read options.


The quality of this board depends on the quality of the posts. The only way to guarantee thoughtful, informative discussion is to write thoughtful, informative posts. AppleNova is not a real-time chat forum. You have time to compose messages and edit them before and after posting.
  quote
iBrowse
Member
 
Join Date: May 2004
Location: The Shire
 
2004-07-06, 19:24

Quote:
Originally Posted by Brad
LoCash, aren't you the one that told me just to use phpMyAdmin for AppleNova DB issues? For the terminal- or manual-phobic, there's a simple "export" option with a number of easy-to-read options.

I was just going to recommend phpMyAdmin for this, painfully simple. Either that or I was going to make a test database on my machine and do this for you and just have phpMyAdmin print out the code to do it for me and paste it here for you. I personally hate MySQL's syntax. hate. hate. hate.

i thought i used to have a signature
  quote
SilentEchoes
Unique Like Everyone Else
 
Join Date: May 2004
Location: Rochester, NY
Send a message via AIM to SilentEchoes  
2004-07-06, 19:52

Mysqls syntax isnt all that bad. It just get complicated with sub-statements and things like SELECT (SELECT * FROM ATable) as foo FROM BTable WHERE ID = (SELECT * FROM CTable);
  quote
Posting Rules Navigation
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off

Post Reply

Forum Jump
Thread Tools

« Previous Thread | Next Thread »

All times are GMT -5. The time now is 21:10.


Powered by vBulletin®
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004 - 2024, AppleNova