l i n u x - u s e r s - g r o u p - o f - d a v i s
L U G O D
 
Next Meeting:
August 5: Social gathering
Next Installfest:
TBD
Latest News:
Jul. 4: July, August and September: Security, Photography and Programming for Kids
Page last updated:
2003 Apr 23 09:27

The following is an archive of a post made to our 'vox-tech mailing list' by one of its subscribers.

Report this post as spam:

(Enter your email address)
Re: [vox-tech] Need your help in recovering database.
[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

Re: [vox-tech] Need your help in recovering database.



Hi,

What is the exact error DBI is giving you?  Also, where are you getting the 
error.  Is it in the connect, or is it later?  Is part of it succeeding or 
not?  

Mike


On Wednesday 23 April 2003 02:50 am, Soumyadeep nandi wrote:
> Hi All,
>
> As a naive to this field, I want to get rid of a
> problem, for that, I am keen, awaiting your
> suggestions. I doubt, I could not present my case in
> front of you properly. Anyway, my problem spins around
> the following.
>
> I've created a database which is suppose to handle
> large number of data. The database is having four
> tables. One of them is the largest holding 10,66,014
> rows, and others having around 10,000 rows. I am using
> perl DBI script to dump data to the tables.
> But suddenly while updating data with perl script it
> started giving error like
>
> My server has gone away...
>
> Then I've shutdown the mysql and the system. When I
> restarted the mysql, then I encountered the error:
>
> Didn't find any fields in table 'blast_genescan'
> This for all the tables.
>
> Then after enquirying for the problem in the datafile
> (i.e. in my system /var/lib/mysql) I found
> 'ibdata1' file is of '2350907392' size. What I guess,
> this might be giving me the error.
>
> I am using 256MB RAM, having 40GB HD out of which 5GB
> is meant for /var
> /dev/hda5       5036284   3679460   1100992  77% /var
> (after loading the database)
>
> The my.cnf file in my system is as follows:
> ================================================
> [mysqld]
> port = 3306
> datadir=/var/lib/mysql
> socket=/var/lib/mysql/mysql.sock
> skip_locking
>
> #pasted from link shown in Tim Hendersens reply...
> # You can write your other MySQL server options here
> # ...
> #                      Data file(s) must be able to
> #                      hold your data and indexes.
> #                      Make sure you have enough
> #                      free disk space.
> innodb_data_file_path = ibdata1:120M:autoextend
> #                      Set buffer pool size to
> #                      50 - 80 % of your computer's
> #                      memory
> set-variable = innodb_buffer_pool_size=70M
> set-variable = innodb_additional_mem_pool_size=10M
> #                      Set the log file size to about
> #                      25 % of the buffer pool size
> set-variable = innodb_log_file_size=20M
> set-variable = innodb_log_buffer_size=8M
> #                      Set ..flush_log_at_trx_commit
> #                      to 0 if you can afford losing
> #                      some last transactions
> innodb_flush_log_at_trx_commit=1
>
> [mysql.server]
> user=mysql
> basedir=/var/lib
>
> [safe_mysqld]
> err-log=/var/log/mysqld.log
> pid-file=/var/run/mysqld/mysqld.pid
>
> ================================================
>
> Please advice me what should I do now to retrieve the
> database.
> Have I lost the database?
>
> Hoping to hear from you.
>
> with regards,
> Soumyadeep
>
> __________________________________________________
> Do you Yahoo!?
> The New Yahoo! Search - Faster. Easier. Bingo
> http://search.yahoo.com
> _______________________________________________
> vox-tech mailing list
> vox-tech@lists.lugod.org
> http://lists.lugod.org/mailman/listinfo/vox-tech

-- 
wenk@praxis.homedns.org
Mike Wenk
	
_______________________________________________
vox-tech mailing list
vox-tech@lists.lugod.org
http://lists.lugod.org/mailman/listinfo/vox-tech



LinkedIn
LUGOD Group on LinkedIn
Sign up for LUGOD event announcements
Your email address:
facebook
LUGOD Group on Facebook
'Like' LUGOD on Facebook:

Hosting provided by:
Sunset Systems
Sunset Systems offers preconfigured Linux systems, remote system administration and custom software development.

LUGOD: Linux Users' Group of Davis
PO Box 2082, Davis, CA 95617
Contact Us

LUGOD is a 501(c)7 non-profit organization
based in Davis, California
and serving the Sacramento area.
"Linux" is a trademark of Linus Torvalds.

Sponsored in part by:
Appahost Applications
For a significant contribution towards our projector, and a generous donation to allow us to continue meeting at the Davis Library.