mysql

nullpt · 07-30-2003, 06:09 AM

Hello buddys,

Can anyone tell me how can I backup my databases in mysql cmd?

And how can i load'em back?

Thanks a lot.

[][]

acid_kewpie · 07-30-2003, 06:36 AM

see "man mysqldump" on dumping databases

nullpt · 07-30-2003, 06:57 AM

yes, but dump will really "dump" the database?

Will it disapear? I don't want that i just want to create a backup.

mysqldump - text-based client for dumping or backing up mysql databases
, tables and or data.

It's not clear in the man pages if those examples will dump and/or backup the dabatases/tables.

That's why I asked.

Thansk [][]

acid_kewpie · 07-30-2003, 06:58 AM

oh no it won't alter the original, just spew it out in a plaintext (i think) version which can be reinserted somewhere else, it;s completely safe.

nullpt · 07-30-2003, 10:56 AM

Ok, i've done it. Everything is untouched. Thanks.