mySql error 1005 (errno: 150) solution This mysql error occurs when creating a table with the InnoDB engine and is basically telling you that there is a "foreign key problem" with your schema. The thing to check to fix this error is to make sure that your foreign key fields are of the same datatype as their source fields. As an example, assume the main table is "people", … [Read more...] about mySql error 1005 (errno: 150)
MySQL
MySQL: How to Change the Database Name
Once you've created a MySQL database and named it you cannot rename the database using standard SQL commands such as ALTER in the same manner as you would rename a table. The way to rename a database is as simple as creating a new, empty database, and then recreating the old database in this new database. Here are the detailed steps: 1. Run a mysqldump on the existing … [Read more...] about MySQL: How to Change the Database Name