Domain Registration from
$12.50/year
Domain Registration from
$12.50/year

FAQs

MYSQL / PHP

How do I create a database?

On your control panel click the 'mysql manager' button. From there you need to create the database, then create a user name, then grant that user name access to the database.

Are my databases backed up?

Yes, all database are backed up nightly using 2 different methods.

Is Perl DBI available for MySQL?

Yes, we have perl DBI installed with the MySQL DBD.

What extensions should I use for PHP?

You can use .php, .php3 .phtml, .php4

How To dump database?

To dump the database it is first recommended that you turn off your forums in your control panel: 1. Telnet into your web server. 2. type in: mysqldump -u[username] -p[password] [dbname] > [/path/to/where/you/want/the/dump/file/dbname.txt] 3. ftp into your web server. 4. Find the dump file in the location you specified. 5. Download the file to your HD and open it with a text editor (Notepad, Wordpad, MS Word, etc) 6. All of the user info will be displayed towards the bottom of that text file. If you can find your user name in there (good luck! ) then your password will be right next to it.

How do I manually backup my db via phpmyadmin?

Go to your control panel -------> MySQL Databases -------> PhpMyAdmin

Click on the database you want to backup (from the left menu)

On the Right side, you will see Database YOUR_DATABSE running on localhost as the title

Scroll down to View dump (schema) of database

1. select all tables you want to backup

2. select Structure and data

3. Checkmark Save as file

4. Hit Go

This will then ask you to save the file to your hard drive, select yes

To restore your sql database

do this :

mysql -u username -p dbname < dumpname.sql

And in case you're putting this in a new database, first create one
like this :

mysqladmin -u username -p newdbname

And remember, if you're not doing this locally, add the -h stuff.

What php modules are compiled with your php?

'./configure' '--with-apxs=/usr/local/apache/bin/apxs' '--with-xml' '--enable-bcmath' '--enable-calendar' '--with-curl' '--with-dom' '--with-dom-xslt' '--with-dom-exslt' '--enable-exif' '--with-swf=/usr/local/flash' '--enable-ftp' '--with-gd' '--with-jpeg-dir=/usr/local' '--with-png-dir=/usr' '--with-xpm-dir=/usr/X11R6' '--with-gettext' '--with-imap' '--with-imap-ssl' '--with-kerberos' '--enable-mbstring' '--enable-mbstr-enc-trans' '--enable-mbregex' '--with-mcrypt' '--with-mhash' '--with-ming=../ming-0.2a' '--enable-magic-quotes' '--with-mysql=/usr' '--with-openssl' '--enable-discard-path' '--with-pear' '--with-pgsql=/usr' '--enable-sockets' '--enable-track-vars' '--with-ttf' '--with-freetype-dir=/usr' '--enable-gd-native-ttf' '--enable-versioning' '--enable-wddx' '--with-xmlrpc' '--with-zlib' plus http://69.93.241.199/~infocom/phpinfo.php

Categories: 28 | Questions: 909

Categories: 30 | Questions: 183

HELPDESK

WEB HOSTING SOFTWARE VERSIONS

  • 4.4.9, 5.2.28

  • 4.1.22. 5.0.67

  • 11

  • 2.11

  • 4.4.9, 5.2.28

  • 4.1.22. 5.0.67

  • 11

  • 2.11

top


SecurityMetrics Credit Card Safe

Developed by