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.

0
Answered

mySQL database size getting large

rick85251 10 months ago in Website / Databases 0
Is it possible to have too large of a mySQL database. I have a website with 120 pages. The mySQL database is 5853.01 MB. Is this too large? If it is too large how would I reduce it?
I have redesigned the site a few times over the years and there may be junk in the database. I am unsure how to cleanup a database. Guidance and best practice is appreciated.
Thank you,
Rick
0
Answered

error when trying to copy SQl DB to an empty one.

in PHPMyAdmin, when I try to copy an sql to an empty one I made using the wizard it gives me an error. Also the new database that I created in the wizard doesnt show up in the left hand panel to open.
0
Answered

I cannot connect to my phpmyadmin database

ebing 2 years ago in Website / Databases 0
I read the tutorials but I couldnt connect from my php webpage to the server
1=localhost, localhost:3306 or domain.com?
2=userdb or general user cpanel hosting?
3=pass
mysql_connect("1", "2","???");
0
Answered

how to retrieve DB Backup

Sweetoro 2 years ago in Website / Databases 0
Hi,
I have not renewed hosting.
I would like to know if you can recover the backups of the db associated with the following websites:
articolivari.it, virganto.com, sweetoro.com.
Best Regards
0
Answered

How to Define a User/Password for Connecting to DB

InMotionFans 3 years ago in Website / Databases 0
where can i find privillage defenition for my DB? where should i set and assign a user name and password of my DB?
0
Answered

Piwik autoupdate not working

InMotionFans 3 years ago in Website / Databases 0
Hi there,
on my site, Piwik has been installed using softaculous. Worked great.
Now when I use the auto-update-function in the Piwik UI, I only get an error page (xxx for privacy)
http://www.xxxxxxxx.shop/piwik/index.php?module=CoreUpdater&action=oneClickUpdate
that says
"Mysqli prepare error: MySQL server has gone away"
That's not an error I have seen before in my other Piwik installations.
Is there a hint what I can do? To me it sounds as if the system doesn't get hold of the db server quickly enought.
Thank you!
0
Answered

Moving MySQL Data Directory

stsIT 3 years ago in Website / Databases 0
In short, I need to quickly create a temporary table of about 500,000+ rows and insert a single character in a new column after all the other columns (regardless of how many there are) and then "select * into outfile" in a data directory in which the user can access. What directory should I write to (the MySQL Data directory? The tmp directory? a separate directory?) and how should I give the correct permissions so that I do not receive a "do not have permissions" error?
0
Answered

Puttygen 'Load' goes nowhere

jerrywaxman 3 years ago in Website / Databases 0
http://www.inmotionhosting.com/support/website/ssh/shared-reseller-ssh
Download and Convert the SSH Key
Step 7. Open puttygen, and click the Load button.
When I click Load, nothing happens.
Is there a step missiong
0
Answered

Mysql access denied on my server

InMotionFans 3 years ago in Website / Databases 0
Dear, I am looking to acces to a new data base mysql that i was created. i am receiving the following message: mysqli_connect(): (HY000/1045): Access denied for user 'xxxxxxx'@'xxxx.xxx.xxx.xxx' (using password: YES) in /home/insihn5/public_html/write_data.php on line 8 1. user exist. 2. This user is attached to data base t with ALL PRIVILEGES Please, let me know if you have an idea to solve this problem.
0
Answered

Connect to Database as Root

stsIT 3 years ago in Website / Databases 0
I have obtained root access and I can SSH into the sever as the root but how can I connect to the Database as the root remotely with either PHP or MySQL Workbench?