Gossamer Forum: General: Databases and SQL: Copying whole database on NT?

Dec 4, 2003, 4:09 AM

Andy

Veteran / Moderator (18441 posts)

Dec 4, 2003, 4:09 AM

Post #1 of 3

Shortcut

Copying whole database on NT?

Hi. Just a quickie. I know I can use 'mysqldump' to dump the records from a table, and then use 'mysql' to re-import them into another database, but this is pretty time consuming when you are dealing with 2+million entries.

So, my question is... can I just copy the .MYD and .MYI files directly on the server?

Cheers

Andy (mod)
andy@ultranerds.co.uk

Dec 4, 2003, 11:36 AM

Alex

Administrator (9387 posts)

Dec 4, 2003, 11:36 AM

Post #2 of 3

Shortcut

Re: [Andy] Copying whole database on NT? In reply to

Yes, .myd files are binary compatible across most o/s. See:

http://www.mysql.com/doc/en/MyISAM.html

for details.

Cheers,

Alex
--
Gossamer Threads Inc.

Dec 5, 2003, 12:32 AM

Andy

Veteran / Moderator (18441 posts)

Dec 5, 2003, 12:32 AM

Post #3 of 3

Shortcut

Re: [Alex] Copying whole database on NT? In reply to

Yeah, I just played with it yesterday, and copied all data from c:/mysql/database_name/* into the other databases folders Cool

Cheers

Andy (mod)
andy@ultranerds.co.uk