Re: INNODB database size

://dev.mysql.com/doc/refman/5.0/en/innodb-configuration.html Regards Pure Web Solution http://www.purewebsolution.co.uk PHP, MYSQL, Web Design & Web Services Todd Smith" <[EMAIL PROTECTED]> wrote: > Hello > > I have inherited an INNODB database. I am new to MySQL and ma

Re: CREATE TABLE x AS with ENGINE = ARCHIVE

I dont think that it is possible to specify the engine when creating a table this way, you could however create the table using the: CREATE TABLE old AS SELECT * FROM request_log and then issue an alter table command setting the engine to whatever you like. Pure Web Solution http

Re: Complicated select query

try something like this select customer,max(time),name from customers join projects on projects.parent_id=customer.id group by customer; regards Pure Web Solution http://www.purewebsolution.co.uk PHP, MYSQL, Web Design & Web Services Barry <[EMAIL PROTECTED]> wrote: > Gabrie

Re: How to take dump of a query instead of table / database

you can manipulate mysqldump using the where clause (check the man) You might find the following usefull, but would not be so good for restoring. from the command line mysql --database=db_name --execute="select * from users" -u username -ppassword > output.file Pure Web

Re: Very large from

Pure Web Solution http://www.purewebsolution.co.uk PHP, MYSQL, Web Design & Web Services "fbsd_user" <[EMAIL PROTECTED]> wrote: > Thank you Gabriel, more background information may result in a > better concept, so here it is. > > The web based application I am writi

Re: How to build a client?

you can add --old-password when starting MySQL manually or try adding the following to the my.cnf file [mysqld] old-password regards Pure Web Solution http://www.purewebsolution.co.uk PHP, MYSQL, Web Design & Web Services My /etc/my.cnf does not have this option? Is this something I can