Ubuntu Servers :: MySQL "duplicate Entry" Error
Jun 14, 2010
I'm trying to migrate a physical server to virtual hardware. The old server runs RHEL 4 with MySQL version 4.1.12. The new server runs Ubuntu 10.04 with MySQL 5.1.41.
In order to export all the MySQL databases from the old server to the new server, I ran the following command on the old server:
Code:
I then attempted to import them on the new server with:
Code:
The command successfully imports about half the databases, but then fails when it gets to a particular table in a database for one of our custom web applications. The error message is:
Code:
I've located that line in the dump.sql file, and as far as I can tell it's not actually a duplicate entry. I've also gone through dozens of bug reports and forum posts about an issue where this situation arises because a key is not set to auto-increment, but in this case the key is set to auto-increment.
View 2 Replies
ADVERTISEMENT
Jul 1, 2010
When I run the update manager and start updating, I get this error:
W: Duplicate sources.list entry http://archive.canonical.com/ubuntu/ lucid/partner Packages (/var/lib/apt/lists/archive.canonical.com_ubuntu_dists_lucid_partner_b inary-i386_Packages)
View 1 Replies
View Related
Nov 14, 2010
This error comes from the update manager, but I can not see duplicate entries in the software sources. Is there a program that removes duplicate sources? If not how do I find the duplicate entries. Quote:W: Duplicate sources.list entryhttp://archive.canonical.com/ubuntu/ maverick/partner i386 Packages/var/lib/apt/lists/archive.canonical.com_ubuntu_dists_maverick_partne r_binary-i386_Packages)
View 5 Replies
View Related
Jun 17, 2010
I have installed Mysql in Ubuntu 9, for the use of roundcube database.After installing iam getting the error like this
* Stopping MySQL database server mysqld [ OK ]
* Starting MySQL database server mysqld [ OK ]
* Checking for corrupt, not cleanly closed and upgrade needing tables.
So because of this in the roundcube configuration its giving the error message that MYSQL is not installed. So Kindly give me a idea how to solve this.
View 1 Replies
View Related
Jan 14, 2011
i was trying to allow remote access to mysql by following mysql was running perfectly until i got here :
Code:
/sbin/iptables -A INPUT -i eth0 -s 192.168.1.0/24 -p tcp --destination-port 3306 -j ACCEPT
i changed my.cnf bind-address line to : "bind-address = 127.0.0.1" and nothing
[code]....
View 4 Replies
View Related
Jan 1, 2011
having a problem with logrotate. it's complaing about a duplicate log entry but there isn't a duplicate log entry that i can see.
View 4 Replies
View Related
Oct 27, 2010
When I run "sudo apt-get update", it says the following:
"W: Duplicate sources.list entry [URL] Packages (/var/lib/apt/lists/archive.canonical.com_ubuntu_dists_lucid_partner_b inary-i386_Packages)
W: You may want to run apt-get update to correct these problems"
Herewith I've attached my sources.list file.
# deb cdrom:[Ubuntu 10.04 LTS _Lucid Lynx_ - Release i386 (20100429)]/ lucid main restricted
# See [URL] for how to upgrade to newer versions of the distribution.
deb cdrom:[Ubuntu 9.10 _Karmic Koala_ - Release i386 (20091028.5)]/ karmic main restricted
deb [URL] lucid main restricted
deb-src [URL] lucid main restricted .....
View 4 Replies
View Related
Apr 17, 2011
Whenever I run $aptitude update I get this error :-
W: Duplicate sources.list entry http://ftp.us.debian.org/debian/ stable/non-free amd64 Packages (/var/lib/apt/lists/ftp.us.debian.org_debian_dists_stable_non-free_binary-amd64_Packages)
W: You may want to run apt-get update to correct these problems
[code]....
View 11 Replies
View Related
Feb 18, 2010
If in Software Sources I have "Download from" set to "Server for Australia", then when I run sudo apt-get update, I get a warning at the end
Code:
Reading package lists... Done
W: Duplicate sources.list entry http://dl.google.com stable/main Packages
[code]....
View 3 Replies
View Related
Jan 3, 2010
I am facing some strange problem of mysql replication with ssl, my replications which working fine from more than 6 months currently stopped working after i upgrade mysql in to newver version mysql-5.1.41-2, i create new ssl self singed certs but still no sucess, when client try to connect the master using ssl its gives error SSL connection error ERROR 2026 (HY000), with out ssl its working f9.
Platform --> Fedora-11 + mysql-5.1.41-2 (both master/client)
I can seeking the problem on net, and i found the below bugzilla url related to that.
[url]
I read it but not get , either new version support x509 ssl certs or not or either new version support ssl replication or not, here below my server configuration for ssl serts
And for client
Both server and clients certs are signed with same ca but still its currently not working after the mysql upgrade first 5.1.41 and then 5.1.41-2
Either as above bugzilla url, currently mysql support ssl replication or not, or either some need to do special for working with ssl. or i wait for newver version of mysql to fix if its bug or not.
View 2 Replies
View Related
Dec 2, 2010
Trying to export a Mysql query to a .csv file the query draws from multiple tables, e.g. sales, purchase and currency
Code:
What i'm trying to do is to export both the sales and purchase to a single line where both the currency for the sales and the purchase is specified.
Basically like this:
Code:
Problem here is that i'm stating currency.value twice in the same select and don't know how to define which currency.value applies to sales and which to purchase.
View 7 Replies
View Related
Apr 13, 2011
I'm getting duplicate entries in mysql database when submitting a new item from a form. I initially loaded the database via IMPORT function in phpMyAdmin. This is my input form:
<center>
<br />
<FONT SIZE="5" ><b>Add Item Template</b></FONT>
<br />
[code].....
However, I do need to return the input form in order to keep entering new items into the database.
View 8 Replies
View Related
May 6, 2011
When looking for MySQL GUI, I find many applications which provide a frontend to database management.I am looking for a GUI for database entry, rather than database management, approximating Glom or VFront, but Glom is buggy (and development sluggish) and VFront difficult to get set up.Ideally, I would have my own private (GTK, say) data entry tool, which would look much like an HTML form, with labelled fields for the MySQL columns, Previous/Next buttons, saving the current row and moving you up/down to the next one, radio buttons or drop-down menus for columns with limited entries, etc.Of course, [Tab]-navigation and keyboard shortcuts [Ctrl]+[C], etc., should work as well. (Yes, that is very annoying about Glom, for example.)
View 2 Replies
View Related
Aug 10, 2010
I already have my laptop as a server using a LAMP server + proftpd and the FTP->MySQL link up. I built myself a new Headless and set up the SSH and VNC on it and all that good jazz. LAMP works and everything. Proftpd+MySQL (using the proftpd-mod-mysql package from repo) doesn't seem to work on this headless box. So I used the tutorial from [URL]... Thinking "I'm using 10.04 - it's close enough". Both came up with the same error. 421 Service not available when I ftp from the localhost. Is their something I'm missing? the Laptop set up (also 10.04) works groovy fine. Also all the log files are blank.
View 2 Replies
View Related
Jun 7, 2011
I think this goes here, but I'm not sure. I decided that XAMPP had been troublesome enough. MySQL never worked. So I decided to instal the LAMP stack offered by YaST. I went about installing it thinking that it would all work. But it seems that I was wrong. So I try to start mysql, and here's what I get:
Code:
the-matrix:~ # mysql start
ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/mysql/mysql.sock' (2) or
Code:
the-matrix:~ # rcmysql start
Starting service MySQL warning: /var/mysql/mysql.sock didn't appear within 30 seconds
chmod: cannot access `/var/run/mysql/mysqld.pid': No such file or directory
[Code]...
View 6 Replies
View Related
Jul 19, 2010
I have set up a MySQL database which has only three fields for user-name, password and index number. But there is a LOT of data (thousands of columns) which would take too long to enter manually. I'm sure MySQL must have a file format whereby a single large file containing different data types can be successfully automatically imported and the various data elements distributed to their intended fields. Does anyone know which characters MySQL uses as field seperators for this formatting of data, or is there a program already written which can take raw data and organize it into a SQL compatible file?
View 8 Replies
View Related
Jan 31, 2010
Target F12 mysql - 5.1.42-2
Source FC 5 mysql - 5.0.27-1
I've put SElinux into permissive mode as it was practically denying anything that moved. Both installed from the standard repos. I used mysql-administrator to create a backup of the FC5 server (all databases/tables) and transferred it to the new system. I restored it onto that machine and double checked that my standard admin user (full privs) was present and let me log in to make changes. All good so far.
So I copied over my files from my sites, point a browser at them and I get nothing, not even errors. Now it's a long while since I set the original up and have probably forgotten something simple but despite making the error output more verbose I can't seem to track anything down other than:
[Code]....
So it suggests my tables are invalid/trashed but I can't seem to figure out why. The original server is still running happily so I'm not in any rush to fix this, I'll keep plodding, Phpinfo reveals a normal operational php setup, so i think that side of the sites is functional. Apache test pages work on blank virtual hosts but viewing my sites reveals the favicon working fine but otherwise comepletely blank pages (zero output, even source). I tried running the page as a raw CLI input to the php package using php index.php and php returned nothing, logged nothing unusual but sat with my CPU at 100%, unsure if that is related.
View 1 Replies
View Related
Apr 2, 2011
ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2). I've had this problem to the point where I thought I messed up my actual configuration so bad that I reinstalled Ubuntu to get rid of all the MySQL configuration; I ran MySQL through Windows with a breeze, but I'm getting some errors like that after restarting my computer just a few minutes ago and I have not changed anything in my SQL settings. I'm on Ubuntu 10.10 64 bit and running MySQL 5.1. the actual error that I get from Navicat and from the website is at [URL]... Update: 20110402. Connection for controluser as defined in your configuration failed. Just got that when I tried to log in to phpmyadmin.
View 4 Replies
View Related
Mar 26, 2010
I set up a servber on my local machine, & also PHp - Both working fine.I'm trying to load up MYSQL i have installed it, & *can* start/stop the server. however if I do anything else with it, I get this error :-
Quote:
root@gordon-desktop:~# sudo mysqladmin -u root -h localhost password MYPASSWORD
mysqladmin: connect to server at 'localhost' failed
error: 'Access denied for user 'root'@'localhost' (using password: NO)'
Query :-
1) How do I know MYSQL is actually active ? (apart from the message it says that its statrted (or stopped).
2) Is there a way to
a) Find out the usernames that are recorded on the MYSQL server ?
b) set / RESET the 'root' username (I know MYSQL root user is different to PC root user)
c) anything else I can do on the PHP / website code to see if MYSQL is working
(as yet, no tables / databases etc have been set up - as I can't get past this error message - I get the same error when setting up a database.)
Ps I did allow my usermname (when logged in to ubuntu) to edit / create files in the /usr/www/ directory (but it is still OWNED by 'root' - that directory)
View 4 Replies
View Related
Jun 12, 2010
I have a LAMP on Ubuntu 10.4 The MySQL is binded to a specific IP of a lan. When the system starts, the MySQL fails to start returning this error
[Code]...
View 3 Replies
View Related
May 5, 2011
i'm not the most knowlegable person but i have successfully installed mysql in the past. but now that i am attempting to install it again i'm getting this error during installation. has anyone seen this before?
mysql error: *Starting MySQL database server mysqld [fail] invoke-rc.d: initscript mysql, action "start" failed. dpkg: error processing mysql-server-5.0 (--configure): subprocess post-installation script returned error exit status 1
View 6 Replies
View Related
Sep 26, 2010
getting foll error during 'make' part of compilation of mysql v5.5.6rc
Code:
libtool: link: unsupported hardcode properties
libtool: link: See the libtool documentation for more information.
libtool: link: Fatal configuration error.
code....
View 9 Replies
View Related
Apr 10, 2010
After the upgrade from 8.10 to 9.04, all was well. But after the upgrade from 9.04 to 9.10, I lost the MySQL server. Now, I recall during the upgrade, I was asked if I wanted to keep the existing my.cnf file or replace it with a newer one. I did as suggested and kept the original as I had edited it before. The same question was asked with a couple other config files. I kept the original in each case. After the first step, I checked the server was running and the websites were up, all was well. After the update to 9.10, when I checked the server, I get the following error:
Code: error: 'Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2)' Check that mysqld is running and that the socket: '/var/run/mysqld/mysqld.sock' exists! Can anyone point me in the right direction to getting this resolved?
View 2 Replies
View Related
Apr 28, 2011
how to upgrade from mysql5.1 to mysql5.5 version. Pls guide me in briefly.I did upgrade with the help of this url
http://www.ovaistariq.net/490/a-step...-to-mysql-5-5/ but i got error like this error:2002: Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2) when trying to connect FATAL ERROR: Upgrade failed
In /etc/my.cnf , i didnt get like this. Is this is the error
user = mysql; socket = /var/run/mysqld/mysqld.sock; port = 3306; basedir = /usr/local/mysql; datadir = /usr/local/mysql/data; tmpdir = /tmp; log_error = /var/log/mysql/error.log
View 1 Replies
View Related
Feb 27, 2011
I'm the lead Dev of GnackTrack and we're having issues with running MySQL on the LiveDVD.Once installed everything works fine, mysql can be connected to but when using the liveDVD we get the following error:
Code:
root@root:~# mysql
ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2)
Contents of /etc/mysql/my.cf point to /var/run/mysqld/mysqld.sock but because this is a liveDVD the actual file is located in:
/rofs/var/run/mysqld/mysqld.sock
[code].....
View 4 Replies
View Related
Dec 6, 2010
I've downloaded and installed MySQL-client-5.1.53-1.glibc23.x86_64.rpm. I'm rather new to linux so it might be I haven't started the server. Unfortunately I have no idea which file is responsible for that. It is also possible that my head isn't functioning correctly ( if at all ).
Error I receive is:
ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2)
View 6 Replies
View Related
Feb 22, 2011
I've been attempting to set up a LAMP for local web development, which meant installing mysql-server. But now have a problem when trying to run mysql, I get:-
ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2)
When trying to downgrade mysql-server I saw that there are dependency problems between the various modules (but can't recall which). But whichever route I truied the results are always the same.
Thought about trying XAMPP but I note that even has it's problems, is there any way I can get a lamp set up on FC14, or must I give it up as a bad job.
Howver, just been trying to again to fix the problems with downgrading mysql and get:-
Error: Package: mysql-server-5.1.55-1.fc14.i686 (@updates)
Requires: mysql(x86-32) = 5.1.55-1.fc14
Removing: mysql-5.1.55-1.fc14.i686 (@updates)
mysql(x86-32) = 5.1.55-1.fc14
View 7 Replies
View Related
Jan 16, 2011
I have mysql downloaded and when I type mysql into the command line I get this:
ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (111)
View 6 Replies
View Related
Apr 3, 2010
I'm trying to install snort-2.8.5.3 on centos5-i386 an I get this error from ./configure --with-mysql --enable-dynamicplugin command:
ERROR: unable to find mysql headers (mysql.h)
checked in the following places
/usr
/usr/include
[Code].....
I've read here it has to do with libmysqlclient12-dev. How can I install libmysqlclient12-dev on centOS?
Is it possible to install snort from repositories using yum?
View 3 Replies
View Related
Jun 4, 2009
I have MySQL 5.1.34 and PHP 5.1.6 installed on my system, how do I install php-mysql? Each time I try, it says
mysql-5.0.45-7.el5.i386 from base has depsolving problems
-- > mysql conflicts with mysql-server-community
error: mysql conflicts with mysql-server-community
View 16 Replies
View Related
