Creating/importing mysql database when host doesn't allow creation of databases from script (php)

Question

I asked similar question before and got some nice code, but i'm concerned with one of comments. I asked how to create and import mysql database from sql file in php on shared hosts. One of commenters said that some hosts might not allow me to do so from php. After digging a bit on other places someone suggested that I could create database from hosts control panel but import it by creating tables via php script executing sql queries this way:

         mysql_query("CREATE TABLE `TABLE NAME HERE` (
        `id` int(25) NOT NULL default '0',
        `CLMN NAME HERE` varchar(250) collate latin1_general_ci default NULL,
        `CLMN NAME HERE` int(10) default NULL,
        PRIMARY KEY  (`id`)
        ) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci;");

        mysql_query("INSERT INTO `TABLE NAME HERE` VALUES ('VALUE HERE', 'VALUE HERE', 'VALUE HERE');");

Could anyone comment on that? How do I achieve what i'm trying to do if given host will have restrictions on what i can do with databases in php?

(I'm not sure if creating new question for that is appropriate, but i thought that since previous question have good examples of doing it if host isn't blocking everything i'll create separate question for doing the same if host is more restrictive.)

longneck · Accepted Answer · 2009-07-24 19:25:18Z

1

shared hosts and frequently do not allow you to create databases, except using their control panel. this is not uncommon, and it's done for good reasons.

and if you can't do it from phpmyadmin or any other administration tool other than their control panel, you won't be able to do it in PHP either.

your only solution in that case is to create the database first using the host's control panel, then edit your backup file and comment out the CREATE DATABASE statement before executing it.

answered Jul 24, 2009 at 19:25

longneck

12.3k3 gold badges39 silver badges49 bronze badges

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

Comments

Ben Reisner · Accepted Answer · 2009-07-24 14:44:30Z

0

I would be suprised if a host did not allow you to execute CREATE TABLE statements from PHP code.

What was most likely referred was a block on CREATE DATABASE statements. Typically you will have been assigned a database name already, so you would never execute a CREATE DATABASE statement on a shared host.

answered Jul 24, 2009 at 14:44

Ben Reisner

6621 gold badge6 silver badges16 bronze badges

1 Comment

Phil Over a year ago

Really? What about multiple database hosts? I also seen one that allowed only one database but it wasn't created automatically from my username, I had to create it manually in control panel.

Collectives™ on Stack Overflow

Creating/importing mysql database when host doesn't allow creation of databases from script (php)

2 Answers 2

Comments

1 Comment

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

1 Comment

Your Answer

Sign up or log in

Post as a guest

Linked

Related