Return »
MySQL information
Questions
Answers
  1. How can I access PHPMyAdmin?

    The link to PHPMyAdmin can be found in the control panel.

    You must login to the control panel from our main website. After logging in, you click the domain name you want the MySQL information for, and then the MySQL tab.
    [Back to top]
  2. How do I backup MySQL databases on my own machine?

    There are two methods that a customer can use to easily back up the database contents at home. One method is to use the PHPMyAdmin database administrator from the MySQL tab in the control panel, or use mysqldump.exe to "dump" contents into a text file at home.

    mysqldump.exe can be downloaded from our system via the download mysqldump.exe link

    In order to use mysqldump.exe you must know the database host, database username, database password and the name of your database. All the required information can be found in the control panel. You must login to the control panel from our main website. After logging in, you click the domain name you want the MySQL information for, and then the MySQL tab.

    Syntax for mysqldump:

    mysqldump -h databaseserver -u user -ppassword mysqldatabase > dump.sql

    As shown there is no space between -p and the password.

    Data is now stored in the dump.sql file for later import.
    [Back to top]
  3. How do I create a connection to MySQL from PHP?

    This is a simple example on how to access information in MySQL from PHP.

    $host="mydatabaseserver";
    $user="mysqlusername";
    $passwordsql="mysqlpassword";
    $database="mysqldatabase";
    $sql_statement="insert into mytable (name,lastname) VALUES ('testname','testlastname')";
    $linkId=mysql_connect($host,$user,$passwordsql);
    $result=mysql_db_query($database,$sql_statement,$linkId);
    //
    // fetch...
    //
    $sql_statement="select name,lastname from mytable where name='testname' and lastname='testlastname' ";
    $linkId=mysql_connect($host,$user,$passwordsql);
    $result=mysql_db_query($database,$sql_statement,$linkId);
    $row = mysql_fetch_array($result);
    $navn=$row["name"];
    $efternavn=$row["lastname"];
    mysql_close;
    ?>

    [Back to top]
  4. How much space do I have for MySQL?

    Each database have 750 Mb of space allocated. So in total, it's 3 gigabytes of space for data. 4 databases are allocated per customer.
    [Back to top]
  5. What versions of MySQL is available?

    All customers with MySQL database subscription are allocated 4 different MySQL servers. To be compatible with any software that uses MySQL, we provide all customers with different versions of MySQL:

    4.0, 4.1, 5.0,5.1,5.5,5.6 and 6.0 alpha

    All the required information can be found in the control panel. You must login to the control panel from our main website. After logging in, you select the domain name you want the MySQL information for, and then the MySQL tab.
    [Back to top]
  6. Where can I find information about my MySQL servers?

    All the required information can be found in the control panel.

    You must login to the control panel from our main website. After logging in, you click the domain name you want the MySQL information for, and then the MySQL tab.
    [Back to top]
Jump to:
Show all categories
Show as printable