 |
| |
|
| »•« |
Limitations and other Information. -
|
| |
The following limitations are currently effective regarding all of our web hosting accounts:
1. You cannot connect to any of your databases from remote hosts. This limitation is due to security concerns. For now you may only connect form localhost.
2. You may not utilize the data-infile data-outfile functions of the mySQL server. This is due to security reasons.
|
| - Updated: Saturday, March 02, 2002 |
|
 |
| |
|
| »•« |
How do I convert a Microsoft Access database to a MySQL database? -
|
| |
There is a program located here that will help you convert databases:
http://www.cynergi.net/exportsql/ |
| - Updated: Saturday, March 02, 2002 |
|
|
| |
|
| »•« |
Connecting to mySQL through PHP. -
|
| |
Use the following outline to connect and begin querying the mySQL server from within your PHP scripts. Remember that you cannot connect to your databases remotely due to security reasons. You can only connect to them form localhost.
1. Connect To The mySQL Server
Use the following statement to connect to the database server. Substitute the username, and password for the ones you had created.. MYSQL_CONNECT('localhost','USERNAME','PASSWORD');
2. Select Your Database
Use the following statement to select the database you wish to connect to. Make sure you substitute the example with your database name. @mysql_select_db("DATABASENAME");
|
| - Updated: Saturday, March 02, 2002 |
|
|
| |
|
| »•« |
Is my MySQL database backed up with my web site data every night? -
|
| |
Unfortunately MySQL databases can not be backed up unless the MySQL server is turned off or tables will become corrupted in the databases.
It is suggested that you keep a backup of your database by doing a dump of the database with the structure and data. This can be done with the online MySQL editor that is installed with each database. If you need any help with this please email support@1stdesign.net. |
| - Updated: Saturday, March 02, 2002 |
|
|
| |
|
| »•« |
Connecting to mySQL through Perl using the mySQL Perl Module. -
|
| |
Use the following outline to connect and begin querying the mySQL server from a Perl script. Remember that you cannot connect to your databases remotely due to security concerns, you can only connect from localhost.
1. Declarations
You must require the mySQL package for your script to function properly. Do this by including the following line in your code: use Mysql;
2. Connect To The Database
Some where near the beginning of your script, you need to make your initial connection to the database server. Using the following form, substitute your database, username, and password for the examples to connect successfully. The database must be a valid one that you had created .
Mysql->connect('localhost','DATABASENAME','USERNAME','USERPASSWORD');
3. Executing A Query
You are now ready to begin querying the database server. Most problems that you may incur will generally occur due to syntax errors. |
| - Updated: Saturday, March 02, 2002 |
|
|
| |
|
| »•« |
Creating/Deleting/Editing Databases and Users -
|
| |
To create or delete a database or users e-mail support@1stdesign.net with the name of database, username and password. You can administrate your MySQL database through a web based interface which we install when we create the database for you. |
| - Updated: Saturday, March 02, 2002 |
|
|
|
