|
Databases / MySQL Overview
- MySQL Version
Which MySQL Version is used on my server?
- MySQL Specifications
What specifications do I need for MySQL?
- MySQL Management
How do I manage my MySQL databases?
- External Database Access
Is it possible to access my MySQL database externally?
- Uploading MySQL Database
"Error Message" appears while uploading the MySQL Database
- mysqldump
Where can I find "mysqldump" ?
MySQL Version
Which MySQL Version is used on my server?
You can find information about the MySQL version currently installed by clicking here.
Top
MySQL Specifications
What specifications do I need for MySQL?
Specify 'localhost' as your server. The name of your database, user name and your password can be found in your domain config menu.
http://www.phpmyadmin.net/
Top
MySQL Management
How do I manage my MySQL databases?
Using ServerCon (Customer login-->click on domain) not only can you create and delete Databases, you can also install the admin tool "phpMyAdmin". phpMyAdmin is an easy to use tool with which you can access your Database.
Please Note: phpMyAdmin takes up about 7 MB Disc Space of your account.
You can also install phpMyAdmin yourself. Download the up to date version from the phpMyAmin website and follow the installation instructions: http://www.phpmyadmin.net
Top
External Database Access
Is it possible to access my MySQL database externally?
Accessing your database externally from your home computer or other server for example, is possible when using the packages Power, business and Premium. If you wish to access your database externally please contact our support team via e-mail.
Top
Uploading MySQL Database
"Error Message" appears while uploading the MySQL Database!
If you receive the error message "CPU Limit reached" while uploading your MySQL Database, your database is too big to upload via phpMyAdmin (about 2MB limit).
The solution to this problem is Bigdump:
First of all download Bigdump from Alexey Ozerov:
http://www.ozerov.de/bigdump.zip
Open the packed file with WinZIP or WinRAR. You now have the file "bigdump.php". Open the file with an editor of your choice, e.g. Windows Editor (Notepad).
Now you have to make the following changes:
In most cases "localhost" is correct. If not quote the name of your database server.
$db_server="localhost";
Fill in your DB name here.
$db_name="DB-Name";
Fill in the user name for your database here.
$db_username="DB-User";
Fill in the user password for your Database here.
$db_password="DB Password";
Backup file name.
$filename="nameofsqlfile.sql";
Number of lines to be processed during a session.
(change only if bigdump cancels aborts upload)
$linespersession=3000;
Time in milliseconds between sessions. Will only work if javascript is activated (Change only if bigdump aborts upload).
$delaypersession=0;
Save changes and upload the "bigdump.php" together with your sql file via FTP. Both file must be situated in the same folder and be chmod 777. Upload in ASCII mode.
Now access bigdump.php using your browser(example: www.<yourdomain>.com/directory/bigdump.php) then click on start import.
If your import is successful the message "Congratulations: End of file reached, assuming OK" is shown.
Please delete your sql file and bigdump.php after finishing.
Top
Mysqldump
Where can I find mysqldump?
The path to "mysqldump" is:
/usr/local/mysql/bin/mysqldump
Top
|
