473,466 Members | 1,324 Online
Bytes | Software Development & Data Engineering Community
Create Post

Home Posts Topics Members FAQ

importing zipped database through phpMyAdmin

49 New Member
Hello Everyone,

I am trying to import zipped database through phpmyadmin and getting this message.

*

#1064 - 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 '<br /> <b>Fatal error</b>: Allowed memory size of 134217728 bytes exhausted (tr' at line 1

Could anyone suggest me how to fix this.

Thanks
Sep 7 '10 #1
3 2939
code green
1,726 Recognized Expert Top Contributor
You have HTML code buried in the SQL syntax.
This will have to be removed before executing the file.
Sep 7 '10 #2
dinesh1985singh
49 New Member
Thanks code :)

but could you have any idea how would I do that from zipped file. Because its not getting unzip.
Sep 8 '10 #3
HaLo2FrEeEk
404 Contributor
Unzip it, remove the HTML, then rezip it?
Sep 8 '10 #4

Sign in to post your reply or Sign up for a free account.

Similar topics

2
by: Adam Clark | last post by:
Is there a way to import a database into another database using code with ADO.NET (assume a microsoft access database in both instances)? I know you could do it with VB6 and DAO. Thanks Adam
1
by: Daniel Manes | last post by:
Some facts: 1) I have an Access database (.mdb file) sitting on my harddrive. 2) I have Visual Studio 2005, Sql Server Express, and Sql Server Management Studio Express. 3) I do *not* have...
2
by: fresher0021 | last post by:
there is a project which has got a dababase .. in sql server .. i neeed to import the database into sql server .. before running the project .. how do i do this ??
5
by: Vik Rubenfeld | last post by:
Is there a way to import an MS Access database .mdb file into MySQL running locally on a Mac? Thanks in advance to all for any info.
13
MMcCarthy
by: MMcCarthy | last post by:
Hi guys, I'm looking for some advice. I have to import a csv file which is on a website page in zip format. I have a piece of code thats supposed to work with winzip but I don't think the client...
1
by: Sudhakar | last post by:
presently i have a table in which there are records and the fields are slno (this is a primary key auto increment), firstname, lastname, email, date(which inserts as a date format) these records...
1
by: rohitsingh0000 | last post by:
hi, i want to import the tables of a oracle database into the sql database.but i am getting errors importing some tables with certain coulms.so far as i got the problem is that a column named D_O_B...
2
by: exipnakias | last post by:
Hello everybody. Let me ask u a question. I would like to know if there's a way (vb code etc) to prevent someone for importing my database's files (table, forms, report, queries etc) to his own or...
4
by: dscharles | last post by:
Hi there- I'm having problems importing a Joomla database to my new server. I've created an empty database on the new server and attached a user with all permissions, but when I hit 'Import' and...
9
by: hajdukzivivjecno | last post by:
I am new user of Python. I would like to change my .shp file that I have astext and it looks something like this (using some loop): to something like this (for every polygon): ((5576309...
1
by: Sonnysonu | last post by:
This is the data of csv file 1 2 3 1 2 3 1 2 3 1 2 3 2 3 2 3 3 the lengths should be different i have to store the data by column-wise with in the specific length. suppose the i have to...
0
by: Hystou | last post by:
There are some requirements for setting up RAID: 1. The motherboard and BIOS support RAID configuration. 2. The motherboard has 2 or more available SATA protocol SSD/HDD slots (including MSATA, M.2...
0
Oralloy
by: Oralloy | last post by:
Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers,...
0
jinu1996
by: jinu1996 | last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven...
0
tracyyun
by: tracyyun | last post by:
Dear forum friends, With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each...
0
agi2029
by: agi2029 | last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing,...
0
by: conductexam | last post by:
I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and...
0
by: adsilva | last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
0
by: 6302768590 | last post by:
Hai team i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated ...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.