Posted by Jerry Stuckle on 07/10/07 11:41

Captain Paralytic wrote:
> On 10 Jul, 11:26, gosha bine <stereof...@gmail.com> wrote:
>> On 10.07.2007 11:12 Robbo wrote:
>>
>>> Hi,
>>> My database contains 45 tables the structure of which is evolving as I
>>> develop. I need a utility that will "read" the structure of this
>>> database and it's tables and then create an identical database with
>>> all tables.
>>> Can you help please ?
>> If your database is Mysql, there are command-line tools mysqldump (for
>> export) and mysql (for import). You can also simply copy the db directory.
>>
>> --
>> gosha bine
>>
>> extended php parser ~http://code.google.com/p/pihipi
>> blok ~http://www.tagarga.com/blok
>
> | You can also simply copy the db directory.
>
> Bad advice! May not work between MySQL versions.
>

It also can cause inconsistent results of MySQL is running at the time,
and generally will not work for INNODB tables.

I agree - a very bad suggestion! Rather, Export/Import or Backup/Restore.

--
==================
Remove the "x" from my email address
Jerry Stuckle
JDS Computer Training Corp.
jstucklex@attglobal.net
==================

• Next in forum: Re: Need script to copy a database and all it's tables
• Prev in forum: Re: Need script to copy a database and all it's tables
• Thread view: Re: Need script to copy a database and all it's tables

[Reply to this message]