database backup

[secondattack]

i need to move my server to another system, what tables do i need to backup to save my players, and custom NPC's?
players to include bots.

[Huppy]

Originally Posted by secondattack

i need to move my server to another system, what tables do i need to backup to save my players, and custom NPC's?
players to include bots.

You Can save the whole database by typing the following (for mysql);
( the destination after the > is an example. Use what you want)

mysqldump -uroot -ppassword peq > c:\backup\peq_backup.sql

You can name the sql file what you want. The "peq" is name of your DB.

Also if you want to back up the login, (whatever you named it, peqlogindb or whatever),
just change the name of "peq" to that of the logindb and the destination file name.

[secondattack]

resource the whole DB would take a good day or so, where as if i knew what tables the custom NPC i have made where stored it would be much less painful.

[lerxst2112]

Have you tried using the command line utilities to do a dump/import? They are very fast compared to trying to dump/import using HeidiSQL or whatever.

[secondattack]

i made the dump with navcat, and tried to restore it with the command line "mysql -umyusername -pmypassword peq < mydumpfile.sql" and it ran for about 4 hours before erroring out, looked to be a little more then half way done. again it would seem to me if all i need to back up was say npc type, spawns, and the other one, forgive me i don't have access the DB and don't remember the tables off hand.. it would be much faster and alot less time consuming to just backup and import those tables into a fresh install.. correct me if I'm wrong. i just need to know which table i need to export/import

[lerxst2112]

Don't use Navicat to dump it. It uses a format that is horribly slow to restore.

Using the command line to dump and restore the database takes me less than 5 minutes. *shrug*

[Huppy]

lerxst2112 is right. I learned the hard way too on my first time, when I
tried using Navicat to backup the database. But since then I have always
used that command line and it takes only a few minutes, whether you are
dumping or restoring.

[secondattack]

right on guys thnx for the help.

[bodi]

When i try to backup the database, I pull up a command prompt, log into mysql by using mysql -uroot -p, then put in my password... then type
mysqldump -uroot -ppassword peq > c:\backup\peq_backup.sql

and it says Error: Unknown command '\b'.

What am I doing wrong?

[Derision]

mysqldump is a separate command line program, just open your command prompt and type the mysqldump command, rather than doing the 'mysql -u root ...' first.

[bodi]

got error: 1045: access denied for user ODBC'@'localhost' (using password:yes) when trying to connect

when i pull up a command prompt it goes to c:\users\name\ btw

[lerxst2112]

From a command prompt just type:

mysqldump -uroot -ppassword peq > backup.sql

Don't run the mysql command first.