programming

I noticed I was using quite some meme references in my Facebook comments such as :sweet jesus: or :mother of god:. So, yesterday evening, I put together an Chrome extension for this. Very simple.

List of memes and other information: http://engin.bzzzt.biz/9gagtension

Source code: https://github.com/engina/9gagtension

This is where you install: Chrome Extension Page

In my previous post about Restoring MySQL Databases from an HDD Image I’ve talked about restoring previous a MySQL development environment from a backup. First of all, there’s a documentation about it, which admittedly I haven’t read. I have simply copied @@datadir and my applications apparently worked fine but Workbench didn’t like it very much. Whenever I tried to expand database tables it kept telling me “Fetching…”. I checked the error logs and it looks something like this:

110406 23:09:00 [Note] Plugin 'FEDERATED' is disabled.
110406 23:09:00 InnoDB: The InnoDB memory heap is disabled
110406 23:09:00 InnoDB: Mutexes and rw_locks use Windows interlocked functions
110406 23:09:00 InnoDB: Compressed tables use zlib 1.2.3
110406 23:09:01 InnoDB: Initializing buffer pool, size = 128.0M
110406 23:09:01 InnoDB: Completed initialization of buffer pool
110406 23:09:01 InnoDB: highest supported file format is Barracuda.
110406 23:09:01  InnoDB: Waiting for the background threads to start
110406 23:09:02 InnoDB: 1.1.5 started; log sequence number 3061735
110406 23:09:02 [ERROR] Missing system table mysql.proxies_priv; please run mysql_upgrade to create it
110406 23:09:02 [ERROR] Native table 'performance_schema'.'events_waits_current' has the wrong structure
110406 23:09:02 [ERROR] Native table 'performance_schema'.'events_waits_history' has the wrong structure
110406 23:09:02 [ERROR] Native table 'performance_schema'.'events_waits_history_long' has the wrong structure
110406 23:09:02 [ERROR] Native table 'performance_schema'.'setup_consumers' has the wrong structure
110406 23:09:02 [ERROR] Native table 'performance_schema'.'setup_instruments' has the wrong structure
110406 23:09:02 [ERROR] Native table 'performance_schema'.'setup_timers' has the wrong structure
110406 23:09:02 [ERROR] Native table 'performance_schema'.'performance_timers' has the wrong structure
110406 23:09:02 [ERROR] Native table 'performance_schema'.'threads' has the wrong structure
110406 23:09:02 [ERROR] Native table 'performance_schema'.'events_waits_summary_by_thread_by_event_name' has the wrong structure
110406 23:09:02 [ERROR] Native table 'performance_schema'.'events_waits_summary_by_instance' has the wrong structure
110406 23:09:02 [ERROR] Native table 'performance_schema'.'events_waits_summary_global_by_event_name' has the wrong structure
110406 23:09:02 [ERROR] Native table 'performance_schema'.'file_summary_by_event_name' has the wrong structure
110406 23:09:02 [ERROR] Native table 'performance_schema'.'file_summary_by_instance' has the wrong structure
110406 23:09:02 [ERROR] Native table 'performance_schema'.'mutex_instances' has the wrong structure
110406 23:09:02 [ERROR] Native table 'performance_schema'.'rwlock_instances' has the wrong structure
110406 23:09:02 [ERROR] Native table 'performance_schema'.'cond_instances' has the wrong structure
110406 23:09:02 [ERROR] Native table 'performance_schema'.'file_instances' has the wrong structure
110406 23:09:02 [Note] Event Scheduler: Loaded 0 events
110406 23:09:02 [Note] C:\PROGRA~2\EASYPH~1.0\MySql\bin\mysqld.exe: ready for connections.
Version: '5.5.10-log'  socket: ''  port: 3306  MySQL Community Server (GPL)
110406 23:13:36 [ERROR] Incorrect definition of table mysql.proc: expected column 'comment' at position 15 to have type text, found type char(64).

If you look careful enough you’ll see please run mysql_upgrade to create it . So I’ve just did it and viola! It looks like fixed. Everything is working fine.

I don’t know what is the proper way of handling this but this is rather a cumbersome process apparently.

You can see your datadir by issuing:

select @@datadir;

Replace this directory with your backed up datadir. Datadir can also be found in my.ini (or my.cnf in GNU/Linux I guess).

When I did, I got the following error while trying to start the MySQL server:

110331  9:56:57 [Note] Plugin 'FEDERATED' is disabled.
110331  9:56:57 InnoDB: The InnoDB memory heap is disabled
110331  9:56:57 InnoDB: Mutexes and rw_locks use Windows interlocked functions
110331  9:56:57 InnoDB: Compressed tables use zlib 1.2.3
110331  9:56:57 InnoDB: Initializing buffer pool, size = 128.0M
110331  9:56:57 InnoDB: Completed initialization of buffer pool
InnoDB: Error: log file .\ib_logfile0 is of different size 0 55574528 bytes
InnoDB: than specified in the .cnf file 0 5242880 bytes!
110331  9:56:58 [ERROR] Plugin 'InnoDB' init function returned error.
110331  9:56:58 [ERROR] Plugin 'InnoDB' registration as a STORAGE ENGINE failed.
110331  9:56:58 [ERROR] Unknown/unsupported storage engine: InnoDB
110331  9:56:58 [ERROR] Aborting

110331  9:56:58 [Note] C:\PROGRA~2\EASYPH~1.0\MySql\bin\mysqld.exe: Shutdown complete

I’ve added “innodb_log_file_size = 53M” parameter to my my.cnf and the server started just fine. You see the 55574528 in the above error log ? That is precisely 53M (55574528/(1024*1024)=53). Though MySQL Workbench still can’t browse the databases in the UI, it tells me

Error:	Time: 10:56:43	Message: Error Code: 1548
Cannot load from mysql.proc. The table is probably corrupted	Details: Get schema contents

Though I can use the databases as below:

use myolddb;
select * from atable;

Even though Workbench is not happy with this, it works. I’ll update if I find anything useful.

Me and my partner got two Sony VAIO VGN-Z790DIB notebooks 1.5 years ago. Admittedly, I still think it is the best PC notebook out there (P9700 CPU, 4G RAM, 1.47kg, ~6h battery). Though, wireless module of my partner’s notebook stopped working in the first month. The wireless module got physically broken, completely disappeared from system as it is not connected at all.

Today, it turned out that these notebooks have some kind of design fault, as mine also got broken. It literally disappeared all of a sudden. It is not a software problem as it is not seen by GNU/Linux or anything.

I tried to order another Wireless Module for VGN-Z790 but all my searches failed. Then, I decided to disassemble it, in hope that I could find a part number etc. After all, I have changed broken parts of my previous notebooks anyway.

It is a very painful task to disassemble this notebook. It took almost 1h to disassemble and assemble the notebook back. Here’s the service manual for VGN-Z series, it is almost impossible to work on this notebook without this. I’d expect a much better service manual from a company such as Sony, but it was quite low quality if you ask me. Dell’s service manuals were way better.

Anyway, I got it! The wireless module of VGN-Z790 is 512AN_HMW. You can see the pictures below.

Luckily, if you search with this model number you can find this part from ebay. I’ll order one soon and see if it is the module that is getting broken or it is something else that is affecting it — only if I don’t get a new notebook! This is a pretty damn good excuse to get one, amarite ?