Import mysql db problem - Printable Version
+- SA-MP Forums Archive (
https://sampforum.blast.hk)
+-- Forum: SA-MP Scripting and Plugins (
https://sampforum.blast.hk/forumdisplay.php?fid=8)
+--- Forum: Scripting Help (
https://sampforum.blast.hk/forumdisplay.php?fid=12)
+--- Thread: Import mysql db problem (
/showthread.php?tid=612235)
Import mysql db problem -
OmegaKiller72 - 15.07.2016
Help please! it happens when i try impot database in Denver
Re: Import mysql db problem -
Parallex - 15.07.2016
What is the name of your .sql file?
Re: Import mysql db problem -
OmegaKiller72 - 15.07.2016
Quote:
Originally Posted by Parallex
What is the name of your .sql file?
|
mydb.sql
Re: Import mysql db problem -
Parallex - 15.07.2016
Quote:
Originally Posted by OmegaKiller72
mydb.sql
|
Try renaming it to fts.sql and reuploading it.
Re: Import mysql db problem -
OmegaKiller72 - 15.07.2016
Quote:
Originally Posted by Parallex
Try renaming it to fts.sql and reuploading it.
|
the same error
Re: Import mysql db problem -
Konstantinos - 15.07.2016
This line was found in the file you are trying to import:
PHP код:
CREATE DATABASE `` DEFAULT CHARACTER SET utf8 COLLATE utf8_general_ci;
As you can see, it is empty; thus an incorrect database name. The correct line would be:
PHP код:
CREATE DATABASE IF NOT EXISTS `fts` DEFAULT CHARACTER SET utf8 COLLATE utf8_general_ci;
So either find and fix that line or remove it completely - the database has been created already.
Re: Import mysql db problem -
OmegaKiller72 - 15.07.2016
Thank you all! i removed that lines in database and it work