similar to: mysql 4 > 5 export import issue

Hello, after I updated from mysql-5.0.22 CentOS 5.0 to mysqld-5.0.45 in CentOS 5.2, mysql looses master-slave sync after one node reboots. I've noticed that the slave doest not respect the informantion on master.info, instead, it tries to read the informantion from the master server file inc-index.index. Let me give a example, the master is alredy on incremental.000006 and the

I just installed CentOS 3.5. Included in the install was mysql. When trying to start it using: service mysqld start. The system responds with mysqld not recpognized as a service. When trying to use /usr/bin/mysql I receive this error: ERROR 2002: Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2). A search of the system does not reveal

Hi Guys, I installed CentOS 6 and installed 'yum install mysql mysql-devel mysql-server' When I try and start MySQL I get: 120206 16:42:07 mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql /usr/libexec/mysqld: Table 'mysql.plugin' doesn't exist 120206 16:42:07 [ERROR] Can't open the mysql.plugin table. Please run mysql_upgrade to create it. 120206

Hello list, I am soliciting opinion here as opposed technical help with an idea I have. I've setup a bacula backup system on an AWS volume. Bacula stores a LOT of information in it's mysql database (in my setup, you can also use postgres or sqlite if you chose). Since I've started doing this I notice that the mysql data directory has swelled to over 700GB! That's quite a lot and

Hello. This is my mysql-server.pp file, both master and client are runing ubuntu. -------------------- class mysql-server { package { "mysql-server": ensure => installed } package { "mysql-client": ensure => installed } service { "mysql": enable => true, ensure => running, require => Package["mysql-server"], } file

I am switching to a composite primary key (string and user ID) from the Rails conventional auto-incrementing integer primary ID. The table is large (2.5 million records) and I''d rather not discard the contents. The composite_primary_key gem doesn''t appear to support altering the table with a migration to do its magic, only creating a table from scratch. So I dumped the table

Hi All I have dozens of these messages on CLI complaining about database connection and error writing CDR to disk. The curious thing is I can find them all inside the database. I "selected" them using uniqueid and manually compared each column with the cdr_adaptive_odbc.c error line. "mysqlcheck -a -e -v DBase" and "mysqlcheck -c -e -v DBase" both returned OK for

Hi. I started mysqld.exe using Wine and it seems to work. But when I try to connect the server seems to answer somehow (connection is established, telnet works) but it seems that no communication takes place. mysql freezes and in telnet no response is shown. Any idea what this could mean? Running in Windows without an installer works so it has to be some problem with wine somehow. Using Ubuntu

I want to backup my current CentOS-7.2 system to another drive. Is it safe to copy the system while it is running? Eg by mount /dev/sdb5 /mnt rsync -HPaxvz /. /mnt/ I've found contradictory advice on the web. -- Timothy Murphy gayleard /at/ eircom.net School of Mathematics, Trinity College, Dublin

Dear listmates, I've recently moved a server from RHEL5 to CentOS 5.3 after it was decided not to renew the subscripton. Everything works beautifully except for Bugzilla, which throws MySQL errors. For example, the sanitycheck.cgi page says: # # # Bugzilla ? Sanity Check * Home * | New * | Search * | * | Reports * * | My Votes * | Preferences

Hi All, I am now working on a plan of what to backup from various servers that I have running I run Apache, so httpd.conf and /var/www/html I run Zimbra currently, so /opt/zimbra/store, /opt/zimbra/my.cnf and /opt/zimbra/db/ I run MySQL, so /etc/my.cnf and /var/lib/mysql Can I simply write a bash script to tar.gz these areas, scp them and put it in a cron job? Is there anything special that

Good day/night/whatever fellow techies, I've come to a small problem managing mysql on CentOS 4.7 box[1]. When I have done things on mysql on my desktop systems it was always just for personal use so I would be lazy and put everything under the "test" db so I didn't have to deal with all that security. But I find that I need to put some db's on the "production"

On Sat, 25 Apr 2015 17:11:34 +0200 jg <webaccounts173 at jgoettgens.de> wrote: > > > Hi All > > > > I have dozens of these messages on CLI complaining about database > > connection and error writing CDR to disk. > > > > The curious thing is I can find them all inside the database. > > I "selected" them using uniqueid and manually

I''ve got my applications running on a server that backs up every hour using MySQLdump. My goal is to take this ''dump'' and re-import it into my desktop computer using MySQLAdministrator. I go through the procedure of restoring this ''backup.sql'' file and it grinds for some time as though something is happening...and then nothing?? There are no error

Hi, I've found some issues upgrading mysql, some people recommends run mysql_upgrade. I wonder why such a script is not run from scriptlet of mysql-server rpm. Thanks in advance -- -- Sergio Belkin LPIC-2 Certified - http://www.lpi.org

i was trying to setup an application checked out from svnin my local machine. i managed to do all that is required except when it came to the step of creating databases for the application, when i tried to connect to mysql i got this error ERROR 2002 (HY000): Can''t connect to local MySQL server through socket ''/var/lib/mysql/mysql.sock'' (2) i have spent more than 5

On 28.04.2016 17:58, Lamar Owen wrote: > On 04/28/2016 08:45 AM, Sergio Belkin wrote: >> I've found some issues upgrading mysql, some people recommends run >> mysql_upgrade. I wonder why such a script is not run from scriptlet of >> mysql-server rpm. > Back in the Dark Ages of the PostgreSQL RPMset (PostgreSQL 6.5), early > in my time as RPM maintainer for the

Todor Petkov wrote: >> I'm running CentOS-7, but I left some MySQL databases >> on my old CentOS-6.5 partition which I'd like to retrieve. >> I assume they are contained in the file /var/lib/mysql/ibdata1 ? >> >> Could I just copy this file to /var/lib/mysql in CentOS-7? >> Or is there some way Mariadb or phpMyAdmin can import mysql databases >>

>> Hi All >> >> I have dozens of these messages on CLI complaining about database >> connection and error writing CDR to disk. >> >> The curious thing is I can find them all inside the database. I >> "selected" them using uniqueid and manually compared each column >> with the cdr_adaptive_odbc.c error line. >> >>

we have multiple servers approx 10 and each has about 100 GB of data in the /var/lib/mysql dir , excluding tar , mysqldump and replication how do we take backup for these databases on to a remote machine and store them datewise , ( the remote machine is a 2TB HDD ) currently tar is not feasible as the data is too huge and the same goes with mysqldump suggestion will be of great help --