how to upload mySQL database to my webhost? At my machine, mySQL uses innodb engine, which is disabled on host - Kahuki Webmaster Forum and Discussion Community

Schlase · #1 (**permalink**) 05-17-2007, 06:47 PM

Error comes when I try to upload through export import and it reaches at '' TYPE = InnoDB;"

troublegum · #2 (**permalink**) 05-17-2007, 06:52 PM

change the scripts to read:
TYPE = myisam

Basher · #3 (**permalink**) 05-25-2007, 02:37 PM

You need to change your table types from InnoDB into MyIsam tables, if your host does not offer InnoDB tables. There is no way you can force the webhost to change table types if they do not support Innodb it would require you to have control of the database server on your hosts platform.

Is there a particular reason your table types are InnoDb , unless your using features specific to Innodb like (field constraints) you can just as easily use MyIsam

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
MySQL database script?	opposition	PHP	3	04-17-2007 08:14 AM
How to Update MYSQL database table based on mysql query array?	blackfox	PHP	2	03-30-2007 01:11 AM
mysql database corrupted?	red_avater	PHP	3	02-14-2007 10:17 AM
How do I link PHP to Mysql Server and how do I upload Php. How do I create forms in PHP using Msql as Database	e-businesses	PHP	2	03-18-2006 06:03 PM
How to access MYSQL database Using PHP in Linux and how to configure Mysql and php for Apache in linux?	passi	PHP	1	03-07-2006 12:12 PM