Re: how to optimize mysql in easy way

2011-10-21 Thread Johan De Meersman
- Original Message - > From: "Benaya Paul" > > 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 way is tools like

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 dynamically create database and tables on mysql?

2011-10-21 Thread Johan De Meersman
- Original Message - > From: "Reindl Harald" > > 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. Prepare by creating a

Re: Maximum line length or statement length for mysqldump

2011-10-21 Thread Johan De Meersman
- Original Message - > From: "Alex Schaft" > > 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 restore time with bot

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, dr

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 Schaft" 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 lot of values clauses