Search options (Page 1 of 4)

I solved this

Changed SET NAMES latin1; to UTF8

Dear Janusz

You are right, I don't know why we couldn't understand this option clearly. Very sorry of that.

 $brain_smashed = $apmuthu_knowledge;  

Thank you apmuthu :-)

I successfully recover .... yuhahahahahah

With the help of your last pdf attachment and some Googling upon full text guide, finally issue solved!

http://www.thegeekstuff.com/2014/04/recover-innodb-mysql

----------------------------------------------------------------------------------------

How to Recover InnoDB MySQL Table Data from ibdata and .frm Files

This tutorial explains how to restore MySQL tables when all or some of the tables are lost, or when MySQL fails to load table data.

One of the reason for this to happen is when the table data is corrupted.

In this particular scenario, when you connect to the MySQL database server, you cannot see one more tables, as they are missing.

Under this scenario, the MySQL log file contained the following messages:

InnoDB: Error: log file ./ib_logfile0 is of different size 0 50331648 bytes
InnoDB: than specified in the .cnf file 0 5242880 bytes!
[ERROR] Plugin 'InnoDB' init function returned error.
[ERROR] Plugin 'InnoDB' registration as a STORAGE ENGINE failed.
[ERROR] Unknown/unsupported storage engine: InnoDB
[ERROR] Aborting
The method explained below will work only for InnoDB database.

Note: Before you do anything, take a backup of all the MySQL files and database in the current condition, and keep it somewhere safe.

To restore the table data you have make sure that data directory and its contents are intact. In my case it was fine.

drwx------ 2 mysql mysql     4096 Oct 11  2012 performance_schema
drwx------ 2 mysql mysql     4096 Dec 10  2012 ndbinfo
drwx--x--x 2 mysql mysql     4096 Dec 10  2012 mysql
-rw-rw---- 1 mysql mysql       56 Dec 19  2012 auto.cnf
drwx------ 2 mysql mysql     4096 Jul 30  2013 bugs
-rw-r----- 1 mysql mysql 50331648 Mar 18 10:35 ib_logfile0
-rw-r----- 1 mysql mysql 50331648 Apr 22  2013 ib_logfile1
-rw-r----- 1 mysql mysql 35651584 Mar 18 10:35 ibdata1
..
Ibdata1 – This file is the InnoDB system table space, which contains multiple InnoDB tables and associated indexes.
*.frm – Holds metadata information for all MySQL tables. These files are located inside the folder of the corresponding MySQL database. (for example, inside “bugs” directory)
ib_logfile* – All data changes are written into these log files. This is similar to the archive logs concepts that we find in other RDBMS databases.
Copy the Files

To restore the data from the above files, first stop the MySQL server.
# service mysqld stop
Copy the ibdata files, and the database schema folder to some other directory. We will use this to restore our Mysql database. In this case, we’ll copy it to the /tmp directory. The name of the database scheme in this example is bugs.

cp –r ibdata* ib_logfile* /tmp

cp –r schema_name/  /tmp/schema_name/
Start the MySQL server:

# service mysqld start
On a related note, for a typical MySQL database backup and restore, you should use the mysqldump command.

Restore the Data

Next, restore the table data as explained below.

In the my.cnf configuration file, set the value of the following parameter to the current size of the ib_logfile0 file. In the following example, I’ve set it to 48M, as that is the size I see for the ib_logfile0 file when I did “ls -lh ib_logfile0″

innodb_log_file_size=48M
Please note that both the ib_logfile0 and ib_logfile1 file size will be the same.

Copy the previous ibdata files to respective position, inside mysql data directory.

cp –r /tmp/ibdata* /var/lib/mysql/
Create an empty folder inside data directory with the same name as the database schema name that you are trying to restore, and copy the previous .frm files inside this folder as shown below:

cp –r /tmp/ib_logfile* /var/lib/mysql/
cp –r /tmp/schema_name/*.frm /var/lib/mysql/schema_name/
Finally, restart the MySQL server.

service mysqld restart
Now you have MySQL server running with the restored tables. Don’t forget to grant appropriate privileges for the clients to connect to the MySQL database.

I don't know how really should I appreciate your kind helps

I read all of references last night. Also I found  those (ibdata1, ib_logfile0, ib_logfile1) files from lost server, attached via below link.
Download Link from my web server

According your kind recommendation & references:
1. I made a virtual machine with Debian 7 and all needed staff, such as phpmyadmin, mysql and ...
2. Create an empty DB with that name
3. Stop MySQL engine
4. Copy those mentioned files in place
5. Gave desire mysql group permission to files and DB files
6. Start MySQL

While starting mysql, it reported can't repair some DB in my made DB.
The only thing that I can't control mysql version compatibility with my lost server.

Sorry for taking your valuable time too much, can you put some effort for the attached files!

Appreciate you kind condolence
I must solve this, don't have any excuse for my friend

still unsolved and very ugly bug

still I am looking for ways to solve it!!!

In accounting for 2 simple reason "allocate payment" is not suitable.

1. We received payment without entering any sales 
2. Received more money than issued invoice

Also accountants have more reason than I wrote here.
In my own opinion this is a bug and have solution to solve it.

apmuthu, any recommendation on how to start this module?

With the budget and knowledge we have it took's a lot for us to create this but we will do that. Your further guideline we boost us more, such as which tables to work with and so on.

Well, there is a big difference here.
Shape of business trades here is vary from US; suppose a business that takes 100's (or more than) of checks from consumers or businesses within a month. Then that business pass away the taken checks to other businesses, like suppliers or etc…, or business issue their own checks to others. Meanwhile here businesses due to backs late encashment or instead of issuing their own company checks pass away taken checks to others, and because of that often put them in banks.

In “Reconcile Bank Account” you can just checkmark and compare with bank statement and this do not alter or change GL. Any change should made at other part like GL or payment entry manually.
Now if that business want to look up for checks they have taken from date to date for encashment or giving to other suppliers what have to do?
For your consideration our type of accounting is accrual and not cash accounting and because of that most of bank transaction based on check.

Dear apmuthu, the only thing I want is to have:

1. Adding another "date" input in "Payment Entry(ies)".
2. For checks look up solution, to add 2 "Date input text" in "Journal Inquiry" with start and end date; this will solve everything because we can easily check what checks should be cashed at specific period of time or when is the checks due dates.