Re: Maximum line length or statement length for mysqldump

2011-10-21 Thread Alex Schaft
On 2011/10/20 03:43 PM, Johan De Meersman wrote: - Original Message - From: Alex Schaftal...@quicksoftware.co.za I realize that, I'm just trying to stop the phone calls saying I started a restore, and my pc just froze I might just read all the single insert lines, and get a whole

Re: How to dynamically create database and tables on mysql?

2011-10-21 Thread Reindl Harald
Am 21.10.2011 10:05, schrieb 王科选: Hi, Is there any way to dynamically create database and tables on mysql? For example, if I want to create 100 databases(dbname is unknown until run time), with 100 predefined tables in it, how to achieve that? Thanks in advance! create database, drop

Re: Maximum line length or statement length for mysqldump

2011-10-21 Thread Johan De Meersman
- Original Message - From: Alex Schaft al...@quicksoftware.co.za Got my app reading in a dump created with extended-inserts off, and lumping all of the insert statements together. Works like a charm Just for laughs, would you mind posting the on-disk size of your database, and the

Re: How to dynamically create database and tables on mysql?

2011-10-21 Thread Johan De Meersman
- Original Message - From: Reindl Harald h.rei...@thelounge.net create database, drop database create table, drop table create table like. I suspect the table names and structures are going to be identical each time - I'm thinking automated blog deployment or something.

how to optimize mysql in easy way

2011-10-21 Thread Benaya Paul
how to optimize mysql in easy way step, i know indexing, mapping other than that is any way. -- Thanks Regards, P.Benaya Paul http://www.codeasearch.com http://www.iwannasearch.com

Re: how to optimize mysql in easy way

2011-10-21 Thread Johan De Meersman
- Original Message - From: Benaya Paul benayap...@gmail.com how to optimize mysql in easy way step, i know indexing, mapping other than that is any way. Forsooth, three paths extend before thee. The right way is to learn about mysql so you know what you're doing. The intermediate