SA-MP Forums Archive
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