Jeff:
Mysqldump don't back up your index, that's your data only.
Osvaldo Sommer
-Mensaje original-
De: Jeff Mckeon [mailto:[EMAIL PROTECTED]
Enviado el: Viernes, 30 de Noviembre de 2007 03:24 p.m.
Para: 'David Campbell'; mysql@lists.mysql.com
Asunto: RE: backup InnoDB db to another
Hi,
on Linux version of MySQL Browser (v 1.2.4 beta), when double-click on
any table, default query is
SELECT * FROM table_name LIMIT 0,1000
On Win version (v 1.2.9 rc), there is no LIMIT part - what caused me to
pull so many times tens, even hundreds thousands of records.
I was looking for
Hi Experts,
I need a small help - I think the solution is not complex, but I am not sure
where to start.
Here is my problem. I have a table that defines the employee to manager
relationship. This table will interface with another system and the users
would be created in the other system. There
The resultant table should be this:
+--+---+--+
| id | name | mgr |
+--+---+--+
| 1001 | Denis Eaton-Hogg | NULL |
| 1002 | Bobbi Flekman | 1001 |
| 1003 | Ian Faith | 1002 |
| 1004 | David St. Hubbins | 1003 |
| 1005 |
You might want to use --single-transaction option when mysqldumping innodb
On Dec 1, 2007 1:20 AM, Jeff Mckeon [EMAIL PROTECTED] wrote:
-Original Message-
From: Jørn Dahl-Stamnes [mailto:[EMAIL PROTECTED]
Sent: Friday, November 30, 2007 11:16 AM
To: mysql@lists.mysql.com
How about looking at the .frm file of the table.
On 11/28/07, Richard Edward Horner [EMAIL PROTECTED] wrote:
FYI, this did not work :)
Thanks though!
Rich(ard)
On Nov 23, 2007 3:37 AM, Paul McCullagh [EMAIL PROTECTED]
wrote:
Maybe this will work:
SHOW CREATE TABLE table_name;