or:
mysqlhotcopy database /path/to/some/dir
info here:
http://www.mysql.com/doc/B/a/Backup.html
mark
Jason Wong wrote:
> On Thursday 04 April 2002 01:29, andy wrote:
> > oh ... on MySQL
>
> mysqldump --opt dbname > /some/where/backup.sql
>
> --
> Jason Wong -> Gremlins Associates -> www.grem
In MySQL:
I am looking for an easy way to create a table that will be
identical to another table in the same database (except the table name,
of course). I do not necessarily need the data duplicated, just the
table structure.
It seems like there should be some type of duplicate_tabl
Perfect. I thought there had to be some simple way to do that.
Thanks a lot,
Mark
Rankin, Randy wrote:
> create table duplicatetablename as select * from mytable
>
> -Original Message-
> From: Mark Lee [mailto:[EMAIL PROTECTED] ]
> Sent: Tuesday, September 24, 20
How about appending " LIMIT _GET[startrow],5" to the end of your query.
The first parameter to LIMIT is the start position and the second is
the number of rows to return.
Does this help, or am I misunderstanding your question?
Mark
Lucas Novæ Matrix wrote:
>Hello,
>
>I am trying to creat
