FAQ's
Pre-Sales Questions
General Account Set Up
DNS Questions
FTP/Files Upload
Control Panel
Web Host Manager
CGI/PERL Scripts
PHP/MySql
Billing Questions
 
  PHP & MYSQL
   
 
  1. How can I set up a MySQL database?
  2. How do I connect to MySQL?
  3. How do I backup and restore my database?
  4. Do I allow to run Bulletin Board written in PHP? Which Bulletin Board would you recommend?
  5. Where can I find free PHP scripts to enhance my site?
   
  ANSWERS
   
  How can I set up a MySQL database?
You can easily set up a MySQL database through your CPanel, under Manage MySQL feature
   
 

How do I connect to MySQL?
Use below information when you configure your scripts:

Server address: localhost
Database name: accountusername_databasename
Username: accountusername_username
Password: password

   
 

How do I backup and restore my database?
Login to your CPanel, and under phpMyAdmin feature. Select all the tables in the right page and then check the "Structure and Data" radio box and 'Save as File' but don't check the zipped or gzipped options. Click 'Go' and it will prompt you to start a download of your database, save it as a .sql file where you will be able to find it later.

Then, if you needed to restore your database, you'd want to login to PHPMyAdmin and check all the tables and 'drop' them. Right below the 'run queries' box on the right page you can select a local file from your computer to upload and run, and that is where you'd pick the .sql file you backed up. It'll take a few minutes to upload and process, and then it should show up fine.

If the file is too large to run via phpMyAdmin, you could always upload it via FTP and send us a support ticket requesting that we import the SQL file into your database, just tell us where the file has been uploaded and what database to load it into, etc. and we'll do it no problem!

   
 

Do I allow to run Bulletin Board written in PHP? Which Bulletin Board would you recommend?
Yes, you can run Bulletin Board written in PHP. Here are a few we would recommend:

    • PHPBB
    • InvisionBoard
    • vBulletion

   
  Where can I find free Perl scripts to enhance my site?
http://www.hotscripts.com/Perl/or http://php.resourceindex.com/
   
   
 
Site requires Macromedia FLASH Player, get Macromedia FLASH Player designed by www.macrodesignstudio.com
 
  © 2004, macrowebhosting.com, Macro Web Hosting [ A division of Macro Design Studio ]  
  All other trade - marks , service marks , registered trade - marks , or registered service marks mentioned in this Website are the property of their respective owners.