473,698 Members | 2,196 Online
Bytes | Software Development & Data Engineering Community
+ Post

Home Posts Topics Members FAQ

unlocked tables in mysqladmin... sucessfully, table still read-only

1 New Member
I moved my tables from one server to another.
I then keep getting table xyz is read-only when I try to update or insert.
I downloaded latest version of phpAdmin and ran it.

I examined the tables that were saying read-only. could not insert into them.
I then executed the sql command for the database "unlock tables;"
I received the messagel, command completed sucessfully.

I then try to do an insert in phpAdmin and still get message
"table in read-only"

HOW DO I UNLOCK THESE TABLE AND ALLOW INSERTS AND UPDATES!

This should NOT be this hard after moving tables.
Oct 14 '06 #1
1 2224
ronverdonk
4,258 Recognized Expert Specialist
Were your tables compressed during the change over?

Ronald :cool:
Oct 15 '06 #2

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

Similar topics

2
9320
by: Rameshwari | last post by:
Hi, I would like to read a ms-word document using python. Basically the word document contains number of tables and the rows in each table do not have same number of columns. Does anyone have a sample code to read a table? Thank you
6
16003
by: David Brown | last post by:
With MySQL is it possible to have indexes or tables held in RAM? If so how do I ensure that updates are copied to disk? Regards, Dave.
2
1887
by: Jitesh K Patil, Systems Engineer, Wipro Technologi | last post by:
Hi All, I am new to mysql. Please let me know where can I find mysqladmin in the linux file system. I have mysql-3.23.41-2 rpm installed. Most of the mysql bin files are installed in /usr/bin, but I could not find mysqladmin. Thanks, Jitesh
1
1751
by: invinfo | last post by:
Years ago there was a version like this. Was it WinMySQLAdmin ? (I'm on Windows XP and using MySQL 5.0.4-beta-nt) and I see mysqladmin is now just CL driven with a command argument, to be executed and mysqladmin stops. Is there any graphical add-on available, to view schema and do various other simple DB management ?
6
2526
by: Don Leverton | last post by:
Hi All, I've got a situation where I am developing an Access 97 app for a client, and am in the "beta testing" stage. I have split the app up, using the DB splitter, into front-end /back-end for the usual reason ... so I can mess with form/report revisions. Since splitting, I've had issues with re-linking the tables ... as it relates to the completetely different "My Documents" data paths on several different Win98 / Win XP computers.
5
1142
by: rzambrano77 | last post by:
Anybody know a application write in php that across a database generate a web application for maintance of tables??. Thank you.
15
43589
by: rajbala | last post by:
hi all, I got the error like $ mysqladmin -h localhost -u root -p create bedrock Enter password: ****** mysqladmin: connect to server at 'localhost' failed error: 'Access denied for user 'root'@'localhost' (using password: YES)' $ mysqladmin --no-defaults -u root ver mysqladmin: connect to server at 'localhost' failed
14
1793
by: Zkidd | last post by:
I hired a designer to do a webpage and the code that they sent me back looks way too long. I am not a developer, but am reading up on web standards, and when I review the source code for web standard xhtml pages, everything looks concise. What I have does not. However, I do read that HTML tables are more robust than CSS because some browsers don't read CSS tables. So maybe, the code that I got, although is long, is worth it? Any...
5
10399
by: stmfc | last post by:
i am trying to use mysql db for the first time. i have installed mysql-noinstall-5.0.45-win32.zip to my pc. although i didnt have set any password, when i try to login for mysqladmin user via command prompt, i am asked for the password then i get ERROR 1045 (28000): Access denied for user 'mysqladmin'@'localhost' (using passw ord: YES) what can i do to reset the password, or to retrieve the password?
5
5109
by: narendrareddy | last post by:
Hi , assume a flat file name emp.txt contains the following data 10000100001 narendranathreddy tallapireddy 01-01-2007 male 10000100002 ravindranathreddy tallapireddy 01-01-2008 male 10000100003 upendranathreddy tallapireddy 01-01-2008 male 10000100004 nagalakshmireddy tallapireddy 01-01-2007 male 10000100005 ruchithareddy tallapireddy 01-01-2007 female 10000100006 narendranathreddy tallapireddy 01-01-2009 male 10000100007...
0
8683
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, people are often confused as to whether an ONU can Work As a Router. In this blog post, we’ll explore What is ONU, What Is Router, ONU & Router’s main usage, and What is the difference between ONU and Router. Let’s take a closer look ! Part I. Meaning of...
0
8609
by: Hystou | last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can effortlessly switch the default language on Windows 10 without reinstalling. I'll walk you through it. First, let's disable language synchronization. With a Microsoft account, language settings sync across devices. To prevent any complications,...
0
9031
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 tapestry of website design and digital marketing. It's not merely about having a website; it's about crafting an immersive digital experience that captivates audiences and drives business growth. The Art of Business Website Design Your website is...
1
8901
by: Hystou | last post by:
Overview: Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows Update option using the Control Panel or Settings app; it automatically checks for updates and installs any it finds, whether you like it or not. For most users, this new feature is actually very convenient. If you want to control the update process,...
0
7739
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, and deployment—without human intervention. Imagine an AI that can take a project description, break it down, write the code, debug it, and then launch it, all on its own.... Now, this would greatly impact the work of software developers. The idea...
1
6528
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome a new presenter, Adolph Dupré who will be discussing some powerful techniques for using class modules. He will explain when you may want to use classes instead of User Defined Types (UDT). For example, to manage the data in unbound forms. Adolph will...
0
5862
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 then checking html paragraph one by one. At the time of converting from word file to html my equations which are in the word document file was convert into image. Globals.ThisAddIn.Application.ActiveDocument.Select();...
2
2336
muto222
by: muto222 | last post by:
How can i add a mobile payment intergratation into php mysql website.
3
2007
bsmnconsultancy
by: bsmnconsultancy | last post by:
In today's digital era, a well-designed website is crucial for businesses looking to succeed. Whether you're a small business owner or a large corporation in Toronto, having a strong online presence can significantly impact your brand's success. BSMN Consultancy, a leader in Website Development in Toronto offers valuable insights into creating effective websites that not only look great but also perform exceptionally well. In this comprehensive...

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.