I have spent most of the day optimizing a Mysql 5.0.x database – now I need to get the changes on to the production server How do I make a backup of table’s index settings and then restore them on ...
I have setup a new mysql database with my webhosting provider and the hostname is not the default localhost it is localhost:/tmp/mysql5.sock I think this is becuase they are moving from mysql 4 to ...
mysqldump: Got error: 1066: Not unique table/alias: 'foo' when using LOCK TABLES when lower_case_table_names=1
I'm trying to dump a MYSQL DB on a linux server (Centos 5.2 32bit, MySQL 5.0.45) In /etc/my.cnf the following value is defined: [mysqld] lower_case_table_names=1 When I try and do a dump with ...
I want to start scheduling remote mysqldump crons, and I'd prefer to use a special account for that purposes. I want to grant that user the minimum permissions for getting a full dump, but I'm not ...