Duplicate database on shared hosting

Question

I'm trying to create a copy of an existing database via a php script on a shared hosting account (specifically Bluehost.com). I can't get the CREATE DATABASE command to work, I tried a few variations of this script: How To Programmatically Create MySQL Databases on Shared Linux Hosting Plans, and the support people say that you can't create a database outside of cpanel. I'm wondering if this is truly the case or if anyone has a way of doing it. I can use phpmyadmin to copy the database, but I really need to automate this process so it can be run by a script on the site.

Thanks in advance for any help!

you can check what permissions you have on the database with show grants for user@host; — Marc B
– Marc B, Commented Apr 20, 2011 at 19:30

Alan Savage · Accepted Answer · 2011-04-20 19:29:13Z

2

Your user account will not have create database privileges. If it did a rogue customer could create hundreds of databases on the server thus severly impacting performance for themselves and other users.

The cPanel will run the CREATE database on your behalf as a user with sufficient privileges granted to create a database.

edited Apr 20, 2011 at 19:29

answered Apr 20, 2011 at 19:22

Alan Savage

8421 gold badge12 silver badges24 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

AJ. · Accepted Answer · 2011-04-20 19:22:38Z

1

I'm guessing you have to pay for another database...the CREATE grant is likely disabled for customers, or you'd be getting services for free.

answered Apr 20, 2011 at 19:22

AJ.

28.3k19 gold badges89 silver badges98 bronze badges

2 Comments

dvanderb Over a year ago

The account comes with unlimited databases, but i'm guessing you're correct in that the 'CREATE' grant is disabled. However, I could still create the same number of databases...it's just going to be more annoying as a manual process.

AJ. Over a year ago

@user532887 - contact your host and explain your requirements. They may make an exception for a single customer if you have an agreement with them in place. IOW, it's possible for them to grant just you with CREATE privs.

Collectives™ on Stack Overflow

Duplicate database on shared hosting

2 Answers 2

Comments

2 Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

2 Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related