PHP and MySQL
- How can I set up a MySQL database?
- How do I connect to MySQL?
- How do I backup and restore my database?
- Do I allow to run Bulletin Board written in PHP?
Which Bulletin Board would you recommend?
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:
|
