This is usually a problem with constraints.  Perhaps the tables aren't being loaded in the right order, etc.  Anyway, I've...

Often times, you need to view a record with lots of fields, and the default mysql horizontal output makes it...

A quick example, using a file of tab delimited values, where "contacts.txt" contains a tab delimited file of the values. ...

This will dump all the tables and fields in your database, showing the field types, and other attributes.  Useful for...

Sometimes you want to just execute arbitrary mysql commands on a one time basis against a mysql database.  This little...

This is a problem with a table or tables being corrupted.  An example error message is: Can't open file: 'cc_pages.MYD'. (errno:...

Suppose you are selecting records from a database, and you want to add some logic to the resulting output.  For...

Use the following command, changing "--all-databases" if you only want specific databases to be dumped: mysqldump --no-data -u root -p --all-databases...

It's easy to accidentally create a mysql table with a reserved word in it. Sometimes it happens when you upgrade...

Sometimes you need to know some information about a table - like the table type, size, etc. If you run...

You can change a field name in an existing table, using the CHANGE keyword:alter table rss_feed change unsubscribe_url referring_url varchar(255)...

Use this format (logged in as root):SET PASSWORD FOR username = PASSWORD('new password');NOTE: make sure you get the exact username...

First, delete all records in the table (assuming you want to start at 1).  Then run this command:   ALTER TABLE tablename...

Use the following command:  SHOW CREATE TABLE [tablename]; This will show you the exact command used to create the table in question,...

To keep your tables clean and easy to decipher, it's advisable to delete any columns that are no longer used. ...

This error generally indicates an issue with disk space on the web server.  The mysql database needs to have space...

There are two options for running sql commands from a file: 1.  All command line: mysql -u [username] -h [hostname] -p [database]...

It's often useful to make "ad hoc" reports that can be brought into excel or another database as CSV files. ...

Sometimes you just need to grab a few records from a table when using mysqldump.  Here's the syntax for doing...

Sometimes on a query you'd like to tally how many records match a specific criteria, but also pull records that...