PEQ and MySQL

Kayot · #1 09-10-2006, 07:37 AM

How do I merge the PEQ sql file into MySQL?

I can do it in chunks. But I want to do it all at once.

I'm using MySQL 4.1.14

How do I merge it?

maverick3n1 · #2 09-10-2006, 08:04 AM

Run c:\mysql\bin\mysql -u root
If you have more than one Dbase, type '\u eq'

type '\. [SQL File path/name]'

make sure you run the files to clear out the SQL dbase before you run the files to create the new one.

Kayot · #3 09-10-2006, 08:18 AM

Cool, it's working. Thank you very much ^-^. I was using myPHPAdmin but this is far better. All at once.

Kayot · #4 09-12-2006, 05:36 AM

How do you dump the database into a sql file? I need to make a backup for my server.

**GeorgeS** · #5 09-12-2006, 04:03 PM

I've got a tool for backups.

http://66.159.225.58/eqemu/eq_db_backup.zip

GeorgeS

herold · #6 09-16-2006, 08:01 AM

Quote:

Originally Posted by GeorgeS

I've got a tool for backups.

http://66.159.225.58/eqemu/eq_db_backup.zip

GeorgeS

Link not working ... if you need a secondary host, plz pm me and I will put it up on my webserver

Kayot · #7 09-18-2006, 03:21 PM

I figured out how to do it. Though now it clumps the data in a (Data),(Data) format. I wish there was a way to make it look like it did in MySQL 4.0. I'm using 5. However the .sql files are smaller ^-^

-- Edit --

opps, forgot to write the how-to. While I put it in the wiki I'll put it here for the non-wiki people.

IF you set your bin path right (If not it's in the mysql sub dir. And you deserve to serch for it because you didn't check the path bin check)

open cmd
type cd\ (Your root should be c:\)
then type this line:
Mysqldump

abaddon · #8 09-26-2006, 02:07 AM

link worked fine for me, I will check it out, however I highly recommend MySQLAdmin which can be found on the Mysql mainsite... I use 1.4 and it is a VERY powerful tool.

as for doing edits I use phpmyadmin it works great but I do agree it really sucks for backup/resotre functions (the combo of it and MySQLAdmin is flawless)