View Single Post
  #2  
Old 10-25-2004, 07:03 AM
Cisyouc
Demi-God
 
Join Date: Jun 2004
Location: Heaven.
Posts: 1,260
Default

On the computer that has the database on it, do this.

Where the text is red, replace with the directory of where you installed MySQL.

Where the text is yellow, replace with your DATABASE'S username.

Where the text is cyan, replace with your DATABASE'S password.

Where the text is green, replace with your BATABASE'S name
==================================
Click START > RUN.
Type in command.com and click OK.
Now, you will see a dos prompt. Type in:

cd C:\eqemu\mysql\

...and hit Enter. You should now see a shell that looks like:

C:\eqemu\mysql\>

Next, type in

mysqldump.exe -u user -p db > eqdb.sql

It will now say

Enter password:

type in your password and hit enter.

The cursor should blink a few min while its saving the db to eqdb.sql. When its finished, you will see:

C:\eqemu\mysql>

Type in EXIT and hit enter.

A copy of the entire database is now available at C:\eqemu\mysql\eqdb.sql for you to source in regularly on the other computer
-
Enjoy!
__________________
namespace retval { template <class T> class ReturnValueGen { private: T x; public: ReturnValueGen() { x = 0; }; T& Generator() { return x; }; }; } int main() { retval::ReturnValueGen<int> retvalue; return retvalue.Generator(); }
C++ is wonderful.
Reply With Quote