Hi, everyone. I'd really appreciate it if someone could help me with this.

We're running MySQL 5.0.22 on a CentOS 5 virtual machine. We need to add another database to our MySQL system, because the volume that stores databases is filling up quickly. We've created another volume, and now we need to be able to create the new database in the new volume without moving the old one. Any help would be great.

Thanks in advance.



Aprile
www.accessdatabaserepair.com - Access Repair Tool

Aprile,
You need first to backup your current database.
Then create a new database.

The syntax in creating a new database is:

CREATE DATABASE [IF NOT EXISTS] db_name;

Then COPY the syntax of the tables you on your existing database.
The syntax to know how your existing tables were created is:
DESCRIBE city;
+------------+----------+------+-----+---------+----------------+
| Field | Type | Null | Key | Default | Extra |
+------------+----------+------+-----+---------+----------------+
| Id | int(11) | | PRI | NULL | auto_increment |
| Name | char(35) | | | | |
| Country | char(3) | | UNI | | |
| District | char(20) | YES | MUL | | |
| Population | int(11) | | | 0 | |
+------------+----------+------+-----+---------+----------------+

then with the above syntax create a table.
Example:
CREATE TABLE IF NOT EXISTS city(
  Id int(11) UNSIGNED NOT NULL AUTO_INCREMENT,
  Name char(35),
  Country char(3) NOT NULL UNIQUE,
  District char(20),
  Population int(11) default '0',
  PRIMARY KEY (Id),
  INDEX (country),
  INDEX (district)
) ENGINE=InnoDB;


i hope this helps.
Good luck!
John