FRIHOST FORUMS SEARCH FAQ TOS BLOGS COMPETITIONS
You are invited to Log in or Register a free Frihost Account!


Importing problems





zellfaze
Code:
Error

SQL query:

-- phpMyAdmin SQL Dump
-- version 2.10.3deb1
-- http://www.phpmyadmin.net
--
-- Host: localhost
-- Generation Time: Feb 12, 2008 at 03:32 PM
-- Server version: 5.0.45
-- PHP Version: 5.2.3-1ubuntu6
SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO";

MySQL said: Documentation
#1193 - Unknown system variable 'SQL_MODE'


Is the error I'm getting. I have the database on my computer, and I'm trying to upload it here. I have a .sql file located here if anyone wants to see what I'm trying to import.


I have php5 and MySQL 5.
MrBlueSky
Setting and using SQL modes is supported by MySQL 5.0 and higher. Frihost uses 4.0. Setting "NO_AUTO_VALUE_ON_ZERO" only has consequences for the way zero's (0) are handled in columns which are set to auto-increment. You can check if you have any zero's in auto-incremented columns. If not, you can propably just remove the SET SQL_MODE line from the dump before importing it. If you do use zeros it might be a bit tricky, they will propably be replaced by new values when you import your dbase without the SET SQL_MODE-line.
zellfaze
Thanks, I found that exporting my database in MySQL 4 Legacy mode works too. Now my problem is of a slightly different sort. It keeps timing out as I try to import the file. I think I know how to fix this though, just chunk up my file and import the chunks.
Related topics
Facing Many Problems
New forum area (computer problems)
Linux or Windows on your computer?!
Problems With Index Page
FTP problems --> Use Filezilla and/or active mode
problems
Problems with provider
Host Problems
Laptop Bootup Problems...
Gmail Problems
Audio problems
i heard so many problems just here
if your operating system has problems..
Help with importing images from a DV camara recorder to pc!!
Reply to topic    Frihost Forum Index -> Scripting -> Php and MySQL

FRIHOST HOME | FAQ | TOS | ABOUT US | CONTACT US | SITE MAP
© 2005-2011 Frihost, forums powered by phpBB.