Rest In Peace
Join Date: May 2004
Location: Atlanta
|
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 |
The Elder™
Join Date: May 2004
Location: The Rostra
|
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? |
quote |
Unique Like Everyone Else
|
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 |
Selfish Heathen
Join Date: May 2004
Location: Zone of Pain
|
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 |
Member
Join Date: May 2004
Location: The Shire
|
Quote:
i thought i used to have a signature |
|
quote |
Unique Like Everyone Else
|
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 |
|
Thread Tools | |