| PHP
and MySQL
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: domainusername_databasename
Username: domainusername_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
|