Tag Info

New answers tagged

3

I just did mysqldump --all-databases in MySQL 5.6.22 for Windows. Neither performance_schema nor information_schema are in the dump. It says so the the MySQL Documentation Restrictions mysqldump does not dump the INFORMATION_SCHEMA or performance_schema database by default. To dump either of these, name it explicitly on the command line. You can ...


1

Solved: ERROR 1030 (HY000) at line 810: Got error -1 from storage engine The above error means you have innodb_force_recovery set in your my.cnf I'm not sure why I couldn't find this easily in mysql documentation, but it's simple enough.


1

Last month, I answered this question : Synchronizing a RDS instance with another RDS instance From researching and answering that post, I recently learned that you can set read_only off on a MySQL RDS Slave. What can this mean for you ? A very unique opportunity. What opportunity ? CONVERT ALL YOUR MyISAM TABLES TO InnoDB !!! Once you have made the RDS ...


0

Not sure if you just want to create a read replica clicks away from you? If not then I guess you need to restore from a dbsnapshot. You can: stop slave. note show slave status. create db snapshot. start slave on first slave. use dbsnapshot to create new rds instance. use co-ordinates to replicate from external master. Also if not and you're looking to ...


1

The ".frm" file holds table definition. You might want to check mysql file-types info. Usually when you move data-base physically do following: Shutdown mysql Copy datafiles to datadir make sure mysql has full permissions on it: chown mysql:mysql datadir/ -R start mysql So, make sure that the tables which are not "visible" have proper permissions for ...


1

Go to folder C:\wamp\bin\mysql\MYSQL_VERSION\bin Hit shift + right-click in that folder and select "Open command window here" from the menu that pops up. This will open a command window in the path you are already in, so C:\wamp\bin\mysql\MYSQL_VERSION\bin Enter any of the MySQL commands you like with any of the executables you find in that folder. To ...



Top 50 recent answers are included