search for: ibdata1

...distribution Type 'help;' or '\h' for help. Type '\c' to clear the buffer. mysql> Now I am getting log file it has error like this . [root at localhost ~]# cat /var/log/mysqld.log 090120 20:52:20 mysqld ended 090120 20:52:29 mysqld started InnoDB: Unable to lock ./ibdata1, error: 38 090120 20:52:29 InnoDB: Retrying to lock the first data file InnoDB: Unable to lock ./ibdata1, error: 38 InnoDB: Unable to lock ./ibdata1, error: 38 InnoDB: Unable to lock ./ibdata1, error: 38 InnoDB: Unable to lock ./ibdata1, error: 38 InnoDB: Unable to lock ./ibdata1, error: 38 InnoDB...

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 >> from a server that is no longer running? > > The C6 partition is part of the new server, so you are able to mount it > an...

...5 07:00 AM, Timothy Murphy wrote: >> 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 from a server that is no longer running? >>> >>> The C6 partition is part of the...

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 from a server that is no longer running? -- Timothy Murphy gayleard /at/ eircom.net School of Mathematics, Trinity College, Dublin

...peration not permitted (1) rsync: failed to open "/var/lib/mysql/ib_logfile0", continuing: Permission denied (13) mysql/ib_logfile0 rsync: failed to open "/var/lib/mysql/ib_logfile1", continuing: Permission denied (13) mysql/ib_logfile1 rsync: failed to open "/var/lib/mysql/ibdata1", continuing: Permission denied (13) mysql/ibdata1 rsync: failed to open "/var/lib/mysql/master.info", continuing: Permission denied (13) mysql/master.info rsync: failed to open "/var/lib/mysql/SCHEDULER/ScheduleTasks.MYD", continuing: Permission denied (13) Any thing I am...

...sive nodes to check them, the web interface sits there doing nothing then the puppetmaster process starts timing out for all nodes compiling their catalogs. Has anyone got a workaround for this? Does it involve cleaning the database from time to time? The box is a VM with 3G of allocated RAM, our ibdata1 file is pretty big, reached 8G recently. So what do others do? Cheers, Steph -- You received this message because you are subscribed to the Google Groups "Puppet Users" group. To post to this group, send email to puppet-users@googlegroups.com. To unsubscribe from this group, send emai...

On 05/29/2015 07:00 AM, Timothy Murphy wrote: > 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 >>> from a server that is no longer running? >> >> The C6 partition is part of the new server, so you are ab...

...4233 120206 16:42:07 [ERROR] Fatal error: Can't open and lock privilege tables: Table 'mysql.host' doesn't exist 120206 16:42:07 mysqld_safe mysqld from pid file /var/run/mysqld/mysqld.pid ended if I go look in /var/lib/mysql I see: -rw-rw----. 1 mysql mysql 10485760 Feb 5 16:53 ibdata1 -rw-rw----. 1 mysql mysql 5242880 Feb 6 16:42 ib_logfile0 -rw-rw----. 1 mysql mysql 5242880 Feb 5 16:33 ib_logfile1 drwx------. 2 mysql mysql 4096 Feb 5 16:55 mysql drwx------. 2 mysql mysql 4096 Feb 5 16:55 test and the 'mysql' is empty. I dont understand, I have never had this issue....

...: <mk8gpm$ea1$1 at ger.gmane.org> > Content-Type: text/plain; charset="ISO-8859-1" > > 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 > from a server that is no longer running? > > -- > Timothy Murphy > gayleard /at/ eircom.net > School of Mathematics, Trinity Col...

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

...sql/fs2.lower-test 090930 18:08:14 [Warning] Can't create test file /mnt/data/mysql/fs2.lower-test 090930 18:08:14 InnoDB: Operating system error number 13 in a file operation. InnoDB: The error means mysqld does not have the access rights to InnoDB: the directory. InnoDB: File name ./ibdata1 InnoDB: File operation call: 'open'. InnoDB: Cannot continue operation. When I temporarily login as user mysql and create the same file it can create the file: $ whoami mysql $ echo a >/mnt/data/mysql/fs2.lower-test $ ls -al -rw-r--r-- 1 mysql mysql 2 2009-09-30 19:15 fs2....

So I got dashboard up and running on our production system on Thursday before I left. Within 48 hours it had completed filled the /var filesystem. The ibdata1 file is currently at 8GB in size. 1. What size should I expect for ~500 nodes reporting every 30 minutes? 2. Are there some database cleanup scripts which I have managed to overlook that need to be run? -- Jo Rhett Net Consonance : consonant endings by net philanthropy, open source and other ra...

...here I have the MySQL data files stored. The databases are Innodb. Creating the volume on the master server works fine and it mounts, and when I mount that on the first mysql node it works fine, too. However, when I try to mount it with the second node I get this error: InnoDB: Unable to lock ./ibdata1, error: 11 InnoDB: Check that you do not already have another mysqld process InnoDB: using the same InnoDB data or log files. This obviously is some sort of locking issue. I've found a few posts where people have said to change "locks" to "plocks" which I have tried withou...

On 29/05/2015 04:52 AM, Timothy Murphy 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 > from a server that is no longer running? The C6 partition is part of the new server, so you are able to mount it and copy files from it, is this...

...of the MySQL server process. To turn it on again: fix the cause, shutdown the MySQL server and restart it. 090323 12:11:50 InnoDB: Operating system error number 13 in a file operation. InnoDB: The error means mysqld does not have the access rights to InnoDB: the directory. InnoDB: File name ./ibdata1 InnoDB: File operation call: 'open'. InnoDB: Cannot continue operation. I don't understand where the problem is. Interesting is that MySQL did not find the file "/clusterfs/log/www1/mysql/mysql.log" which is in the filesystem and chmodded 777 for sure. There are...

...ning...and then nothing?? There are no error messages...just no tables in the empty database that was supposed to have been restored. It is important to point out here that I can accomplish the backup/restore for any MySQL applications on my desktop computer, just fine. I find in the MySQL folder a ibdata1, ib_logfile0 and ib_logfile1 that are VERY large but they are binary and I have no idea what ''jewels of wisdom'' they might offer. Is there anyone out there that could share some insight in how they would restore (partially or full) a backup into their production database? I worry...

...comments mean? I don't think I want to restorecon for a socket: # ls -Z /var/lib/mysql -rw-rw----. mysql mysql system_u:object_r:mysqld_db_t:s0 aria_log.00000001 -rw-rw----. mysql mysql system_u:object_r:mysqld_db_t:s0 aria_log_control -rw-rw----. mysql mysql system_u:object_r:mysqld_db_t:s0 ibdata1 -rw-rw----. mysql mysql system_u:object_r:mysqld_db_t:s0 ib_logfile0 -rw-rw----. mysql mysql system_u:object_r:mysqld_db_t:s0 ib_logfile1 drwx------. mysql mysql system_u:object_r:mysqld_db_t:s0 mysql srwxrwxrwx. mysql mysql system_u:object_r:mysqld_var_run_t:s0 mysql.sock drwx------. mysql mysql s...

...= 10G myisam_repair_threads = 1 myisam_recover # ***************************** INNODB Specific options **************************** innodb_file_per_table innodb_additional_mem_pool_size = 16M innodb_buffer_pool_size = 2048M innodb_data_home_dir = /data/mysqldata3/innodb_ts innodb_data_file_path = ibdata1:256M:autoextend innodb_file_io_threads = 4 innodb_thread_concurrency = 0 innodb_flush_log_at_trx_commit = 1 innodb_log_buffer_size = 8M innodb_log_file_size = 512M innodb_log_files_in_group = 5 innodb_log_group_home_dir = /data/mysqldata3/innodb_log innodb_max_dirty_pages_pct = 20 innodb_lock_wait_...

Le mardi 25 avril 2017 ? 10:39 +0200, Robert Moskowitz a ?crit : > Thanks Laurent. You obviously know a LOT more about SELinux than I. I > pretty much just use commands and not build policies. So I need some > more information here. > > From what you provided below, how do I determine what is currently in > place and how do I add your stuff (changing postgresql with

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