Tag Info

New answers tagged

0

I'm sorry, I don't have a corrupt pg_conversion table to help perform any verifications. My answers here must, by necessity, be heavily based on speculation. With the limited information we have, I am guessing that you are attempting to do a full database pg_dump, along the lines of pg_dump --host 127.0.0.1 --port 5432 --username "postgres" ... ...


1

You will have to mysqldump around moments_production_wp I have old posts to bypass databases and tables Dec 16, 2011 : How do you mysqldump specific table(s)? Feb 20, 2013 : There is any option for mysqldump to ignore databases for backup in mysql Using the same concepts, here is how to mysqldump all except moments_production_wp MYSQL_USER=root ...


0

10 GB of ram -- nothing is threatening to hit this. open_files_limit=10000 -- Try 2000 query_cache_size=256M -- No more than 50M default-storage-engine=MyISAM -- Unless you already have some InnoDB tables, this means that innodb_buffer_pool_size may as well be 0 -- you aren't using it. So, I will guess one of this is the case: 32-bit OS 32-bit build of ...


1

I am not totally convinced MySQL is running out of memory. Here is why: ASPECT #1 When you use mysqltuner.pl, it calculates the total usage in the worst case scenario. It does it by adding 3 figures together key_buffer_size innodb_buffer_pool_size thread_memory : max_connections * the sum of sort_buffer_size join_buffer_size read_buffer_size ...


0

ok, i best solution which suited me well. for being cautious in choosing the above solutions provided in my question above.. (cuz the solutions didn't guarantee 100% that my data would be intact), i made a backup for my drupal database folder just in case. chose solution (2), which is adding the force_recovery..but no luck in fixing the problem.. so i ...



Top 50 recent answers are included