Welcome to the InMotion Hosting
Community Support Center!

It's time to get an answer! Our Customer Community Team monitors questions between 9am - 5pm ET, Monday - Friday!

Remember to ask detailed questions to receive better answers. When necessary, include steps we can take to replicate an issue.


How to find the MySQL backup?

Abetum 4 weeks ago in Website / Databases updated 4 weeks ago 2

Doing a site restore with only a full cPanel backup. Unfortunately we didn't do partial backups and the host provider deleted our data. We can’t find the Mysql database and file. How do we find it? The host provider also checked and couldn’t see the sql


installing wordpress on multiple sites

sandi 7 years ago in Website / Databases 0

I already installed wordpress for a sub-site (squigglybrackets.com). I am trying to install wordpress to run my main site (espritgreen.com) but so far I've been unsuccessful. I suspect it is because of the other wordpress install but I don't know what to do.
I'd appreciate your help.
Thank you!

issue posting customer info to database

alexinmo 7 years ago in Website / Databases 0
I was following along with the tutorial at http://www.inmotionhosting.com/support/edu/website-design/using-php-and-mysql

I've set up the database and table using MySQL Wizard and phpMyAdmin.

I've put together the following 4 php files as instructed:

1. formcode_2.php
2. manage_customer_info.php
3. page1_B.php
4. page2_B.php

When I go the mySite.com/page1_B.php URL I'm able to input my customer information into the fields, and when I click on Submit I get the Thank You message.

The problem that I'm having is that when I go back to phpMyAdmin to see if the information that I entered, the table isn't showing any results. All it says is "MySQL returned an empty result set (i.e. zero rows)."

In the $con = mysql_connect line of my "manage_customer_info.php" file I have "localhost" as the server.

Does anyone know why the information that I entered isn't getting posted on the database?


Automated MySQL backup

Igontech 7 years ago in Website / Databases 0
I'm trying to schedule a mysql backup from cron. The job runs (not a cron) problem, but the mysqldump is empty. The script I'm running in in php, has permissions of 755, and I'm on a shared hosting plan (pro).

Here's a snippet of code with the command I'm trying to execute. In the example below $message is always null and $retval is 0.

Are we allowed to run exec() or system() from php? Perhaps that is my problem. if not, is there a way for me to accomplish this in some other way, like a Perl script or something?

$command = "mysqldump -u{$dbUsername} -p{$dbPassword} $dbName | gzip > $backupPath";

$message = exec($command, $output, $retval);

echo "$backupFile :: $message :: $retval";

Error: Error establishing a database connection

URmothra 7 years ago in Website / Databases 0
I would like to know what is happening with my website. About once an hour I get "Error establishing a database connection" and I get MANY people telling me that they are unable to get to my site on a regular basis. I am fairly new to web administration... Is this a performance issue with my hosting plan or wordpress?

Absolute beginner needs help setting up HTML form to database connection

alexinmo28 7 years ago in Website / Databases 0

I've set up a database table in phpMyAdmin, and have copied and pasted the code below (from a website that I found) into my own HTML file.

I'd like to learn what I need to do to connect this HTML to the "username_myTable" database table that I set up.

The database table has the following columns: firstname, lastname, email, phone, and comment.

My ultimate goal is to be able to collect visitor's information from my website so that I can do email marketing campaigns using the data that would get stored in the database.

Let me know if I should include more information. Any help would be greatly appreciated.

You will receive our response
with a few minutes

first name*

last name*




Modifying a MySQL View in phpMyAdmin

jeffsteil 7 years ago in Website / Databases 0
I am trying to fix a client website and I believe the problem is his views were created with a definer that is no longer in the system. From what I can tell there is no way I can alter a view through phpMyAdmin based on inmotion's security settings. How can I change the definer on the view (or the security type)? Thanks.


How can I change my MySQL database's timezone?

SeenBean 7 years ago in Website / Databases 0
I am a bit unsure how to, but I was wondering if the database's timezone was set on the hosting end. Currently, when I submit data with a CURRRENT_TIMESTAMP, the time is 1 hour behind.

Does anyone know how I can change it? Or could possibly point me to the right direction? Thanks.

EDIT: Ah, so I've found the variables tab on my phpMyAdmin page, and there is a date_format that has been preset. Maybe I can somehow edit that to knock the time back to CST?

MySQLi and PDO result in "no such file or directory" error

50weasels 7 years ago in Website / Databases 0
I am trying to connect to my database using non-deprecated connection methods (e.g., using PDO or mySQLi in preference over mysql_connect).

No matter the method I use, I get a "no such file or directory" error (below). Most help on the web suggests to check the location of my mysqld.sock. I don't know how to do this without SSH...

How do I confirm the location of mySql.sock, verify that PHP is correctly configured and get mysqli or PDO to work on my shared hosting site?

Warning: mysqli_connect() [function.mysqli-connect]: [2002] No such file or directory (trying to connect via unix:///var/mysql/mysql.sock) in /path/to/my/script.php on line 16

Warning: mysqli_connect() [function.mysqli-connect]: (HY000/2002): No such file or directory in /path/to/my/script.php on line 16
Failed to connect to MySQL: No such file or directory

Line 16 is the connection (all variables are set to correct values):
$hostname = 'localhost';
$mysqli = mysqli_connect($hostname, $username, $password, $dbname);

OR very similar error occurs from code in the try block:

dsn = 'mysql:host=localhost;port=3306;dbname=mydb'
try {
$db = new PDO($dsn, $user, $password);
} catch (PDOException $e) {
echo 'Connection failed: ' . $e->getMessage();