473,386 Members | 1,748 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,386 software developers and data experts.

table stays LOCKED with import of sql dump

2
My host went out of buisness, so i ended up with a load of Sql Dumps.
The upload of my site went fine until i tried import the Sql Dump. All i am getting now:

LOCK TABLES `PLD_CATEGORY` WRITE ;
MySQL said:
#1044 - Access denied for user @ Db...
Some guy suggeted removing the "LOCK TABLE" on the Sql file, but this already set to "UNLOCK" TABLES.

I think it is a permissions thing but i am not sure?

Appreciate some advice.
Thank you
Eng65
Mar 5 '08 #1
3 1939
ronverdonk
4,258 Expert 4TB
Welcome to The Scripts!

Please remember to provide a meaningful Title for any threads started (see the FAQ entry Use a Good Thread Title).

This helps to ensure that other members, and also the general public, will have a better chance of finding answers to any similar questions.

MODERATOR
Mar 6 '08 #2
amitpatel66
2,367 Expert 2GB
My host went out of buisness, so i ended up with a load of Sql Dumps.
The upload of my site went fine until i tried import the Sql Dump. All i am getting now:

LOCK TABLES `PLD_CATEGORY` WRITE ;
MySQL said:
#1044 - Access denied for user @ Db...
Some guy suggeted removing the "LOCK TABLE" on the Sql file, but this already set to "UNLOCK" TABLES.

I think it is a permissions thing but i am not sure?

Appreciate some advice.
Thank you
Eng65
This access denied might be because some other session might have locked the table before you could and unles that session executes a ROLLBACK or COMMIT, the table will not get released.
Mar 6 '08 #3
Eng65
2
Thanks for your reply "Roll Back" "Commit" I am not to sure what you mean with this friend? Could you please be more specific.

Thank You
Regards,
Eng65
We all have to start some where, agree? I know you would
Mar 6 '08 #4

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

Similar topics

3
by: John Kolvereid | last post by:
How does one import data INTO a table. I am forced to read files (\i) w/ a ton of insert statements. I am trying to import approx 800 lines into the table. However, I must bundle them into a...
1
by: Robert McEuen | last post by:
Using Access 97 on WinXP I have data in a DB2 table that I'm trying to get into an identical table in my backend db. Based on volume of data and frequency of download, I'm trying to avoid...
1
by: deko | last post by:
I need to import dates from a linked table then export them out as text to an Excel spreadsheet. The problem is the dates need to be in ascending order when I dump them out to Excel - and there's...
5
by: Biguana | last post by:
Hi, Wondering if anyone can help with an append query I'm running in Access. It should add records from an Access table to a linked SQL Server table (linked via ODBC). I run the query by...
5
by: Mike Nolan | last post by:
I have a 600K row table on my production system (running 7.3.3) that I dump and load on my development system (7.4.1) every night using cron jobs. I would like to be able to restore the table...
9
by: Shivam | last post by:
Hi All, I have a mysql dump file... something like. __________________________________________________ CREATE TABLE nation ( ip int(11) unsigned NOT NULL default '0', country char(2) NOT...
3
by: dynamo52 | last post by:
I have a horrible database that i would just like to dump and rebuild but am unable to extract the data. It is a proprietary front-end to access and the only method of export is a badly formatted...
1
by: Nick Craig-Wood | last post by:
I've been dumping a database in a python code format (for use with Python on S60 mobile phone actually) and I've noticed that it uses absolutely tons of memory as compared to how much the data...
4
by: Alvin SIU | last post by:
Hi all, I have 6 tables inside a MS Access 2003 mdb file. I want to convert them as DB2 version -8 tables in AIX 5.2. I have exported them as 6 XML files. The XML files look fine. Each...
0
by: taylorcarr | last post by:
A Canon printer is a smart device known for being advanced, efficient, and reliable. It is designed for home, office, and hybrid workspace use and can also be used for a variety of purposes. However,...
0
by: aa123db | last post by:
Variable and constants Use var or let for variables and const fror constants. Var foo ='bar'; Let foo ='bar';const baz ='bar'; Functions function $name$ ($parameters$) { } ...
0
by: ryjfgjl | last post by:
If we have dozens or hundreds of excel to import into the database, if we use the excel import function provided by database editors such as navicat, it will be extremely tedious and time-consuming...
0
by: emmanuelkatto | last post by:
Hi All, I am Emmanuel katto from Uganda. I want to ask what challenges you've faced while migrating a website to cloud. Please let me know. Thanks! Emmanuel
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
marktang
by: marktang | last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However,...
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...

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.