Hi !
i decided to write here, bc i have no idea what i'm doing wrong...
i use such string for exporting my database
mysqldump database --opt -u root -pass > /home/httpd/domain.com/html/backup/db.sql
but issue is that if i try to import this database into mysql,
i get error:
ERROR 1065 at line 22: Query was empty
and then next about 10 same errors:
i checked that row , here is it:
/!40000 ALTER TABLE comments DISABLE KEYS /;
next errors are about the same thing...
i found out, on mysql help, i have to disable it::
-K, --disable-keys
/!40000 ALTER TABLE tb_name DISABLE KEYS /; and /!40000 ALTER TABLE tb_name ENABLE KEYS /; will be put in the output. This will make loading the data into a MySQL 4.0 server faster as the indexes are created after all data are inserted.
i tried switch -K and --disable-keys , but nothing helped, still such rows in .sql file, anyone having any idea how to turn off these comments ?
thanx
