You Are Here Home > MySQL

MySQL

MySQL: ERROR 1114 (HY000) at line 4424: The table ‘X’ is full

Even though this could be a limitation by your file system check the value of the system variable:

myisam_data_pointer_size

If it’s set to 4 then the table can be a maximum of 4GB in size but if it’s set to 6 then the table can be a maximum of 256TB…

To fix this try:

edit /etc/my.cnf

And add this line to the end of it:

myisam_data_pointer_size = 6

Save it and restart mysql:

service mysql restart

I hope this helps…

MySQL: ERROR 1114 (HY000) at line 4424: The table ‘X’ is full
Comments (0)   Filed under: MySQL, Operating Systems, Server   Posted by: Codehead

WHM/cPanel: MySQL Errors While Manually Transferring Accounts

Errors like:

DELIMITER must be followed by a ‘delimiter’ character or string
or
ERROR X (X): You have an error in your SQL syntax; check the manual that
corresponds to your MySQL server version for the right syntax to use near

If you get those errors the chances are that the MySQL version on the source and destination servers don’t match, most probably the destination server runs an older version of MySQL, to fix this issue, you must let /scripts/pkgacct know your version of MySQL, find out the version, then do something like this:

/scripts/pkgacct UNAME –mysql 4.1
Note: 2 dashes before mysql, they are not showing up here…

Please note that, in my case, my MySQL server was version 4.1 so you may need to change this version number to match your own destination server’s MySQL server version.

I hope this helps someone :)

WHM/cPanel: MySQL Errors While Manually Transferring Accounts
Comments (0)   Filed under: MySQL, Server, WHM/cPanel   Posted by: Codehead

Rearrange/move MySQL Table Columns

To *move* a column to a particular position:

ALTER TABLE `user`
MODIFY COLUMN `permission` int(10)
AFTER `password`

To *move* a column to the beginning:

ALTER TABLE `user`
MODIFY COLUMN `permission` int(10)
FIRST
Rearrange/move MySQL Table Columns
Comments (0)   Filed under: MySQL   Posted by: Hamid

Add a Column To The Beginning Of a Table

Assume that we want to add a column ‘id’ in the beginning of the table ‘test’:

ALTER TABLE test ADD id INT NOT NULL FIRST;
Add a Column To The Beginning Of a Table
Comments (0)   Filed under: MySQL   Posted by: Codehead

Change or Reset The Auto Increment Value

Here is how to change the auto increment value to say 10 on the table ‘test’:

ALTER TABLE test AUTO_INCREMENT 1;
Change or Reset The Auto Increment Value
Comments (0)   Filed under: MySQL   Posted by: Codehead

Add a Column After a Specific Column On a Table

Assume that we want to add a column ‘number’ after ‘pass’ column on table ‘test’:

ALTER TABLE test ADD number INT(12) NOT NULL AFTER pass;
Add a Column After a Specific Column On a Table
Comments (0)   Filed under: MySQL   Posted by: Codehead

Copy An Entire Table – Data & Structure

Assume that we want to copy our ‘user’ table to a table called ‘backup’:

CREATE TABLE backup LIKE user;
INSERT INTO backup SELECT * FROM user;
Copy An Entire Table – Data & Structure
Comments (0)   Filed under: MySQL   Posted by: Codehead

Copy Table Data ONLY

Assume that we want to copy all the data from the table ‘user’ into ‘backup’ table:

INSERT INTO backup SELECT * FROM user;
Copy Table Data ONLY
Comments (0)   Filed under: MySQL   Posted by: Codehead

Copy a Table Structure ONLY

Assume that we want to copy the table ‘user’’s structure into a new table called ‘backup’:

CREATE TABLE backup LIKE user;
Copy a Table Structure ONLY
Comments (0)   Filed under: MySQL   Posted by: Codehead

Create An Index

Assuming you want to create the index ‘name’ on column ‘name’ on table ‘test’:

ALTER TABLE test ADD INDEX name (name) ;

Where the first ‘name’ is the name of the index and the ‘name’ in parenthesis is the column name.

If you want to index 2 columns:

ALTER TABLE test ADD INDEX name (name, pass) ;
Create An Index
Comments (0)   Filed under: MySQL   Posted by: Codehead
Older Posts »