MySQL - Alter Table Fails As Workbench Tries To Create Existing Table I have been trying to add another column to a table in my database using MySQL Workbench. This generates an 'ALTER TABLE' command which then fails as  it fails attempting a 'CREATE TABLE, which it should not be doing as the table already exists!  The output is below:-

ERROR 1114: The table 'Analysis' is full
SQL Statement:
ALTER TABLE `Patient`.`Analysis` ADD COLUMN `TestDateTime` DATETIME
NULL AFTER `idResults`

ERROR: Error when running failback script. Details follow.

ERROR 1050: Table 'Patient' already exists
SQL Statement:
CREATE TABLE `Patient` (
`idAnalysis` int(11) NOT NULL,
`idResults` int(11) DEFAULT NULL,
`ResultPDF` mediumblob,
`ResultCSV` mediumblob
) ENGINE=InnoDB DEFAULT CHARSET=latin1


How can I add this extra column as this database will evolve over time as user requirements expand?

Thank you.
If you have a lot of records in your table, take a look at my answer to a related question here. 

With respect to MySQL Workbench, I have always found the tool to be excellent. 

Having said that, what MySQL Workbench 'may' be doing in the background is creating an empty temporary table with the extra field, copying over all the records, the deleting your old Patient table and renaming the temp table to Patient and then having problems creating the "new" Patient table. You'd have to check the source code to find out for sure what's going on - or maybe run SHOW TABLES; continuously against your system while the update was being performed. 

Where the message "The table "Analysis' is full" is coming from, I don't have a clue - does it exist in your schema? Do you have spare disk space for your MySQL datadir, or is it getting tight?

In any case, if a GUI tool fails, the first thing to do is to is to run the command from the mysql command line tool (another reason to prefer the command line), just to ensure that you're really dealing with a MySQL problem and not an issue with Workbench. Do you have the output of the error log? That might also be helpful.