:: toxpenguin ::

:: repair table mysql database mysql> use dbname; mysql> repair table table_name; :: link + googlelinux

:: what is please take a look this :: backing up all mysql databases used mysqldump command $ mysqldump --all-databases -u root -p | gzip -9 > db_all.sql.gz Enter password: :: restoring all mysql databases $ tar -xzf db_all.sql.gz $ mysql -u root -p < db_all.sql Enter password: :: links + googlelinux + netadmintools

:: how to reset auto increment in mysql mysql> ALTER TABLE table_name AUTO_INCREMENT = 0; 0 = starting value for auto increment :: links + googlelinux + bayublitar