Joomla Templates Club 406,261 posts

[qolby Friend qolbyJoin date: August 2014Posts: 81Downloads:5Uploads:8]

#202805

Hi,
Please, i was trying to upload my website JA Bookshop (Quickstart) to live server from locahost but i got error. so i contacted my hosting provider and i was asked to provide my sql file after then i was replied with the following message.

We have tried to import the provided sql file into the database ‘bookshop_house1’ and the process was terminated with following error.

ERROR 1064 (42000) at line 182: 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 ‘`m9dzi_acymailing_filter`
CREATE TABLE IF NOT EXISTS `m9dzi_acymailing_filter` (‘ at line 1

I request you get back to us with the correct, updated file so that we can import it to the database from our end.

Kindly help to resolve this issue, my client is giving me pressure

Thanks

[jooservices Friend jooservicesJoin date: October 2014Posts: 8556Downloads:0Uploads:130 Thanked: 1245 times in 1121 posts]

#555372

Hi there,
I have bit confuse here. Why you want to import database by manual . For quickstart you can simply install it by follow installation wizard.

Thank you,
Viet Vu

[qolby Friend qolbyJoin date: August 2014Posts: 81Downloads:5Uploads:8]

#555618

Hi,
Sorry, i was only trying to upload my sql file from my local computer to live server but it was showing error. so i contacted my hosting provider and i was asked to send the sql file to help upload from their end after then the reply with the following message.

We have tried to import the provided sql file into the database ‘bookshop_house1’ and the process was terminated with following error.

ERROR 1064 (42000) at line 182: 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 ‘`m9dzi_acymailing_filter`
CREATE TABLE IF NOT EXISTS `m9dzi_acymailing_filter` (‘ at line 1

I request you get back to us with the correct, updated file so that we can import it to the database from our end.

Kindly help to resolve this issue, my client is giving me pressure

Thanks

[jooservices Friend jooservicesJoin date: October 2014Posts: 8556Downloads:0Uploads:130 Thanked: 1245 times in 1121 posts]

#555619

Hi there,
– To install quickstart you can simply install it on live server. No need to do it manually.
– And how did you export sql file to give to your hosting provider ?

Thank you,
Viet Vu

[qolby Friend qolbyJoin date: August 2014Posts: 81Downloads:5Uploads:8]

#555662

Hi,
Please, i have installed quickstart on my local computer using wampserver and i was fine and my site is working on my computer perfectly but now i import the sql file from phpmyadmin trying to upload it on liveserver of my hosting along the line of uploading it shows error
Error

SQL query:

/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;

/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;

/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;

/*!40101 SET NAMES utf8 */;

—
— Database: `cssbookshops`
—
CREATE DATABASE IF NOT EXISTS `cssbookshops` DEFAULT CHARACTER SET utf8 COLLATE utf8_general_ci;

MySQL said: Documentation
#1044 – Access denied for user ‘cssadmin’@’10.%’ to database ‘cssbookshops’

after then i contacted my hosting provider and i was asked to provide the sql file to import it from their end but they couldn’t fix it as they replied with the following message
We have tried to import the provided sql file into the database ‘bookshop_house1’ and the process was terminated with following error.

ERROR 1064 (42000) at line 182: 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 ‘`m9dzi_acymailing_filter`
CREATE TABLE IF NOT EXISTS `m9dzi_acymailing_filter` (‘ at line 1

I request you get back to us with the correct, updated file so that we can import it to the database from our end.

Please, i would appreciate it if you can help me import the sql file to my database. so let me know so i can provide you the sql file and login details on a secure and private room

hoping to hear from you soon

[jooservices Friend jooservicesJoin date: October 2014Posts: 8556Downloads:0Uploads:130 Thanked: 1245 times in 1121 posts]

#555668

Hi there
Please provide your CPanel access & your sql file. I’ll try to help you import it.
And please note if you sql file so large, you can’t import via web UI. Please use console to do.

Thank you,
Viet Vu

[qolby Friend qolbyJoin date: August 2014Posts: 81Downloads:5Uploads:8]

#555669

Hi,
Please, give me secure place like your personal email to provide you the sql file and the login details.
the sql file is just 1.33MB

Thank you so much for your quick response

[jooservices Friend jooservicesJoin date: October 2014Posts: 8556Downloads:0Uploads:130 Thanked: 1245 times in 1121 posts]

#555672

Hi there,
you can send me via PM in forum

Thank you,
Viet Vu

[jooservices Friend jooservicesJoin date: October 2014Posts: 8556Downloads:0Uploads:130 Thanked: 1245 times in 1121 posts]

#555703

Hi there
Confirm your exported SQL file have trouble. Please re-export it via phpmyadmin .
Thank you,
Viet Vu

[qolby Friend qolbyJoin date: August 2014Posts: 81Downloads:5Uploads:8]

#555824

Hi,
Below is the link to download the new exported cssbookshops.sql file for my database or your may check the FileManager using the login details, the new sql file has been uploaded in there.

https://www.dropbox.com/s/6zkeoya6wz…shops.sql?dl=0

Thank you so much

[jooservices Friend jooservicesJoin date: October 2014Posts: 8556Downloads:0Uploads:130 Thanked: 1245 times in 1121 posts]

#555825

Hi there,
Sorry caused your confuse. But i mean your export sql is invalid. That’s why your hosting provider can’t import it ( also me ).
Please re-check it in your localhost and re-export again.

Thank you,
Viet Vu

[qolby Friend qolbyJoin date: August 2014Posts: 81Downloads:5Uploads:8]

#555843

Hi,
I have re-export the sql file from my localhost. please check the file manager using the login details i provided in the PM to help me import it on my database liveserver
i also tried to import it on another localhost computer and it was successful.

Thank you very much

[jooservices Friend jooservicesJoin date: October 2014Posts: 8556Downloads:0Uploads:130 Thanked: 1245 times in 1121 posts]

#555874

Hi there,
It’s imported. Please check at your side.
Actually your SQL still not good at all but i have fixed it.

Thank you,
Viet Vu

[qolby Friend qolbyJoin date: August 2014Posts: 81Downloads:5Uploads:8]

#556186

Hi,
Please, how do you mean by Actually your SQL still not good at…
kindly explain further

Regards

[qolby Friend qolbyJoin date: August 2014Posts: 81Downloads:5Uploads:8]

#556188

<em>@jooservices 453940 wrote:</em><blockquote>Hi there,
It’s imported. Please check at your side.
Actually your SQL still not good at all but i have fixed it.

Thank you,
Viet Vu</blockquote>
Hi,
Please, how do you mean by Actually your SQL still not good at…
kindly explain further

Regards

[Author]

Posts