I had forgotten how to dump a specific table using mysqldumb (normally I just dump the entire DB) but thankfully RolandoMySQLDBA had the simple answer! Thanks for the help “If you are dumping tables t1, t2, and t3 from mydb” mysqldump -u… -p… mydb t1 t2 t3 > mydb_tables.sql via mysql – How do you mysqldump [...]
Last night I had an error show up a couple times while using Navicat to backup database on Weblogs.us. This was the error: [Err] [Bak] 1286 – Unknown table engine ‘InnoDB 00:00:00′ On this server MyISAM was preferred so I had specifically disabled InnoDB, yet something was trying to deal with InnoDB and it was causing the [...]
Question from Steve. Hello, I installed XAMPP on my Window sLaptop and then tried to access it via Navicat from my Desktop as root I get this error: mysql error number 1130 host STEVE-DESKTOP is not allowed to connect to this mysql server Can you please help me? Answer from JD. Sure Steve, I am [...]
If you receive an error from your MySQL databaser server that reads: #1030 Got error 28 from storage engine Then you will want to check and make sure your server has sufficient free space. One of my servers gave this error and it was because the drive that MySQL was installed on had no more [...]
Recent Comments