Note: officeonweb offers mSQLand mySQL databases as a free service to our premium customers. We do not provide tech support for databases; however, we have some tutorials on our site regarding mSQL and PHP.

"mSQL is a easy to use database engine designed to provide fast access to stored data with
low memory requirements." - mSQL Manual

Note: The only types of database that Office On Web permits on our system are mSQL and mySQL. Other database types make heavy use of system resources. Allowing their use would negatively impact the performance of our other clients' web sites

The basics:

• If you need a database activated,just fill in our Tech Support Request Form, requesting that a database be setup (please specify whether you want mSQL or mySQL). Please include your user id and password in the correspondence. The name of your database will be the prefix of your domain name.

For example, if your domain name is yourbiz.com, the name of your database will be:

yourbiz

• Once we have created your database, you can then start using and manipulate tables how you want too. Usually, the easiest is to use text files and pass them to the database. For example:

  Text file textfile.sql containing:

  create table tablename (
  	clientname	char(40),
  	address		char(50),
  	id_number	int)
  	\g 

  and passing to mSQL by issuing the command:

  msql databasename < textfile.sql

One way to make a quick and easy backup of your database is to use msqldump.

1. Run the command msqldump databasename > filename.dump. This creates a flat ascii file with all of the commands necessary to totally recreate your mSQL database. (Warning. If you just run msqldump databasename without directing it to a file, it will only echo to the screen.)

2. You can use this for a daily backup, delete or manipulate your tables, whatever. As long as you have this ASCII file, you're protected.

3. If you are experiencing problems with a table, for example: key fields not working properly, spaces inserted into integers, etc.; you can run an msqldump, delete the current structure, and feed the data back in with the command
   msql databasename < filename.dump. !

Sample msqldump for Database TESTIT

 #
 # mSQL Dump (requires mSQL-1.0.6 or better)
 #
 # Host: localhost Database: testit
 #--------------------------------------------------------
 
 
 #
 # Table structure for table 'TABLE01'
 #
 CREATE TABLE TABLE01 (
 women CHAR(36),
 men CHAR(36),
 numallow CHAR(36)
 ) \g
 
 
 #
 # Dumping data for table 'TABLE01'
 #
 
 INSERT INTO TABLE01 VALUES ('Melissa','Michael','Edwin')\g
 INSERT INTO TABLE01 VALUES ('Maryleese','James','Linda')\g
 INSERT INTO TABLE01 VALUES ('Cindy','Jeff','Jason')\g
 
 #
 # Table structure for table 'TABLE02'
 #
 CREATE TABLE TABLE02 (
 women CHAR(36),
 men CHAR(36),
 numallow CHAR(36)
 ) \g
 
 
 #
 # Dumping data for table 'TABLE02'
 #
 
 INSERT INTO TABLE02 VALUES ('Melissa','Michael','Edwin')\g
 INSERT INTO TABLE02 VALUES ('Maryleese','James','Linda')\g
 INSERT INTO TABLE02 VALUES ('Cindy','Jeff','Jason')\g
 
 #
 # Table structure for table 'TABLE03'
 #
 CREATE TABLE TABLE03 (
 women CHAR(36),
 men CHAR(36),
 numallow CHAR(36)
 ) \g
 
 
 #
 # Dumping data for table 'TABLE03'
 #
 
 INSERT INTO TABLE03 VALUES ('Melissa','Michael','Edwin')\g
 INSERT INTO TABLE03 VALUES ('Maryleese','James','Linda')\g
 INSERT INTO TABLE03 VALUES ('Cindy','Jeff','Jason')\g
 
 #
 # Table structure for table 'TABLE04'
 #
 CREATE TABLE TABLE04 (
 women CHAR(36),
 men CHAR(36),
 numallow CHAR(36)
 ) \g
 
 
 #
 # Dumping data for table 'TABLE04'
 #
 
 INSERT INTO TABLE04 VALUES ('Melissa','Michael','Edwin')\g
 INSERT INTO TABLE04 VALUES ('Maryleese','James','Linda')\g
 INSERT INTO TABLE04 VALUES ('Cindy','Jeff','Jason')\g
 
 #
 # Table structure for table 'TABLE05'
 #
 CREATE TABLE TABLE05 (
 women CHAR(36),
 men CHAR(36),
 numallow CHAR(36)
 ) \g
 
 
 #
 # Dumping data for table 'TABLE05'
 #
 
 INSERT INTO TABLE05 VALUES ('Melissa','Michael','Edwin')\g
 INSERT INTO TABLE05 VALUES ('Maryleese','James','Linda')\g
 INSERT INTO TABLE05 VALUES ('Cindy','Jeff','Jason')\g