Click here to Skip to main content
14,664,780 members
Home » Discussions » Database
   

Database

 
QuestionConfiguring multiple properties or values in SSIS Package using Package Configuration file Pin
indian1432-Apr-18 14:18
Memberindian1432-Apr-18 14:18 
QuestionTrying to insert values into Table Variable in Dynamic Sql Pin
indian1432-Apr-18 13:17
Memberindian1432-Apr-18 13:17 
AnswerRe: Trying to insert values into Table Variable in Dynamic Sql Pin
Mycroft Holmes2-Apr-18 14:22
professionalMycroft Holmes2-Apr-18 14:22 
GeneralRe: Trying to insert values into Table Variable in Dynamic Sql Pin
indian1433-Apr-18 7:49
Memberindian1433-Apr-18 7:49 
AnswerRe: Trying to insert values into Table Variable in Dynamic Sql Pin
Richard Deeming3-Apr-18 8:44
mveRichard Deeming3-Apr-18 8:44 
GeneralRe: Trying to insert values into Table Variable in Dynamic Sql Pin
indian1434-Apr-18 12:35
Memberindian1434-Apr-18 12:35 
GeneralRe: Trying to insert values into Table Variable in Dynamic Sql Pin
Richard Deeming5-Apr-18 8:06
mveRichard Deeming5-Apr-18 8:06 
QuestionMysql database problem Pin
Member 1375522730-Mar-18 18:12
MemberMember 1375522730-Mar-18 18:12 
Hi Everyone, so i have a problem with my MySQL database, whenever i try to import the database i get an error that says

You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near


I was running a site and using VestaCP i wanted to reinstall my server, so i simply exported the database from PHPmyAdmin and then reinstalled the whole server.

Then again i installed VestaCP and now when i am trying to import the Database i get the following error

ERROR 1064 (42000) at line 31734: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ''C:24:"WPSEO_Sitemap_Cache_Data":152414:{a:2:{s:6:"status";s:2:"ok";s:3:"xml";s:' at line 2


It is a wordpress database, i really have no clue as to whats happening. If you guys can help me out i'd appreciate it.

I read some articles on Google, and i think its related to the Mysql or PHp versions. But i couldn't find answers or threads specifically for this issue. So please help me out ASAP because my website is down from days. Thanks
AnswerRe: Mysql database problem Pin
A_Griffin30-Mar-18 21:41
MemberA_Griffin30-Mar-18 21:41 
GeneralRe: Mysql database problem Pin
Member 1375522730-Mar-18 21:55
MemberMember 1375522730-Mar-18 21:55 
GeneralRe: Mysql database problem Pin
A_Griffin30-Mar-18 22:12
MemberA_Griffin30-Mar-18 22:12 
GeneralRe: Mysql database problem Pin
Victor Nijegorodov30-Mar-18 22:45
MemberVictor Nijegorodov30-Mar-18 22:45 
GeneralRe: Mysql database problem Pin
jschell31-Mar-18 7:29
Memberjschell31-Mar-18 7:29 
GeneralRe: Mysql database problem Pin
Victor Nijegorodov31-Mar-18 20:56
MemberVictor Nijegorodov31-Mar-18 20:56 
AnswerRe: Mysql database problem Pin
jschell31-Mar-18 7:34
Memberjschell31-Mar-18 7:34 
QuestionSSIS package and package in a SQL server agent Job Pin
VK1927-Mar-18 8:27
MemberVK1927-Mar-18 8:27 
GeneralRe: SSIS package and package in a SQL server agent Job Pin
CHill6027-Mar-18 22:09
mveCHill6027-Mar-18 22:09 
GeneralRe: SSIS package and package in a SQL server agent Job Pin
VK1928-Mar-18 2:06
MemberVK1928-Mar-18 2:06 
GeneralRe: SSIS package and package in a SQL server agent Job Pin
CHill6029-Mar-18 12:27
mveCHill6029-Mar-18 12:27 
AnswerRe: SSIS package and package in a SQL server agent Job Pin
#realJSOP29-Mar-18 8:54
mva#realJSOP29-Mar-18 8:54 
QuestionApplication stopped working after backup and restoring the Database with another name Pin
indian14326-Mar-18 8:55
Memberindian14326-Mar-18 8:55 
AnswerRe: Application stopped working after backup and restoring the Database with another name Pin
Richard Deeming26-Mar-18 10:00
mveRichard Deeming26-Mar-18 10:00 
GeneralRe: Application stopped working after backup and restoring the Database with another name Pin
indian14327-Mar-18 6:10
Memberindian14327-Mar-18 6:10 
QuestionSQL server job execution time Pin
VK1922-Mar-18 7:47
MemberVK1922-Mar-18 7:47 
AnswerRe: SQL server job execution time Pin
Victor Nijegorodov22-Mar-18 8:40
MemberVictor Nijegorodov22-Mar-18 8:40 

General General    News News    Suggestion Suggestion    Question Question    Bug Bug    Answer Answer    Joke Joke    Praise Praise    Rant Rant    Admin Admin   

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.