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.
Yes, all database are backed up nightly using 2 different methods.
Yes, we have perl DBI installed with the MySQL DBD.
You can use .php, .php3 .phtml, .php4
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.
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.
'./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
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