Home Company Info Testimonials Services & Solutions Customer Support FAQ's Resources
sales@tonservers.com
   
  Pre-Sales Questions
  General Account Set Up
  DNS Questions
  FTP/Files Upload
  Control Panel - CPanel
  WebHost Manager
  Email Questions
  CGI/PERL Scripts
  PHP & MySQL
  Billing Questions

 


More Info | JOIN FREE
Affiliate Login Here

 

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

  1. How can I set up a MySQL database?
    You can easily set up a MySQL database through your CPanel, under Manage MySQL feature

  2. 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

  3. 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!

  4. 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

  5. Where can I find free Perl scripts to enhance my site?
    http://www.hotscripts.com/PHP/ or http://php.resourceindex.com/



 

Copyright © 2002-2007 TON Hosting. All rights reserved.