Broken database?

Next topic

Author	Message
Bjarne MAthiesen	Tuesday 22 January 2008 3:33:12 pm My harddrive has been corrupted ;-( And offcourse it is in the database files of my site, so now it says "no access" As far as I can see, it has lost some tables in the database regarding users. Where can I find the sql that creates the database for mysql? Isn't it possible to repair the database? Please help me. A lot of work is lost if I dont get this back up.
Lukasz Klejnberg	Friday 25 January 2008 4:47:26 am hi if you can copy binary files from directory where is database mysql, like this: /var/lib/mysql/your_database and /var/lib/mysql/ibdata1 and ib_logfile0-... to your new mysql directory. It is the best if you do this operation on local machine, then if you run your database you must export to sql and import to your new database. maybe you must try to find solutions to recovery ibdata1? regards lukasz

Author

Message

Tuesday 22 January 2008 3:33:12 pm

My harddrive has been corrupted ;-(

And offcourse it is in the database files of my site, so now it says "no access"
As far as I can see, it has lost some tables in the database regarding users.

Where can I find the sql that creates the database for mysql?

Isn't it possible to repair the database?

Please help me. A lot of work is lost if I dont get this back up.

Lukasz Klejnberg

Friday 25 January 2008 4:47:26 am

if you can copy binary files from directory where is database mysql, like this:
/var/lib/mysql/your_database

and

/var/lib/mysql/ibdata1 and ib_logfile0-...

to your new mysql directory.

It is the best if you do this operation on local machine, then if you run your database you must export to sql and import to your new database.

maybe you must try to find solutions to recovery ibdata1?

regards
lukasz

eZ debug

Timing:	Jan 31 2025 01:15:13
Script start
Timing:	Jan 31 2025 01:15:13
Module start 'layout'
Timing:	Jan 31 2025 01:15:13
Module start 'content'
Timing:	Jan 31 2025 01:15:13
Module end 'content'
Timing:	Jan 31 2025 01:15:13
Script end

Main resources:

Total runtime	0.0222 sec
Peak memory usage	4,096.0000 KB
Database Queries	3

Timing points:

Checkpoint	Start (sec)	Duration (sec)	Memory at start (KB)	Memory used (KB)
Script start	0.0000	0.0042	589.2578	151.2109
Module start 'layout'	0.0042	0.0035	740.4688	220.6875
Module start 'content'	0.0077	0.0128	961.1563	997.8047
Module end 'content'	0.0205	0.0016	1,958.9609	29.9922
Script end	0.0221		1,988.9531

Time accumulators:

Accumulator	Duration (sec)	Duration (%)	Count	Average (sec)
Ini load
Load cache	0.0026	11.8181	14	0.0002
Check MTime	0.0011	4.8909	14	0.0001
Mysql Total
Database connection	0.0005	2.2172	1	0.0005
Mysqli_queries	0.0018	7.9670	3	0.0006
Looping result	0.0000	0.0409	1	0.0000
Template Total	0.0011	5.1	1	0.0011
Template load	0.0009	3.9684	1	0.0009
Template processing	0.0002	1.0613	1	0.0002
Override
Cache load	0.0006	2.8297	1	0.0006
General
dbfile	0.0016	7.1824	8	0.0002
String conversion	0.0000	0.0312	4	0.0000
Note: percentages do not add up to 100% because some accumulators overlap

Templates used to render the page:

Usage	Requested template	Template	Template loaded	Edit	Override
1	print_pagelayout.tpl	<No override>	extension/community/design/community/templates/print_pagelayout.tpl
Number of times templates used: 1 Number of unique templates used: 1

Time used to render debug report: 0.0001 secs