osx - MySQL: Remove all references to database -

-

while importing dump newly created database, server stopped classic server has gone away message. know why happened , fact did occur isn't part of problem. i've removed database directory /usr/local/mysql/data/ , still mysqld not start successfully, because of log or init file.

the goal fixed without having reinstall mysql.

mysql err log:

innodb: page checksum 1559794421, prior-to-4.0.14-form checksum 641317514 innodb: stored checksum 3364647797, prior-to-4.0.14-form stored checksum 641317514 innodb: page lsn 16 1049927436, low 4 bytes of lsn @ page end 1049927436 innodb: page number (if stored page already) 43379, innodb: space id (if created >= mysql-4.1.1 , stored already) 0 innodb: page may index page index id 0 3302 innodb: (index "some_index" of table "some_database"."some_table") innodb: database page corruption on disk or failed innodb: file read of page 43379. innodb: may have recover backup. innodb: possible operating innodb: system has corrupted own file cache innodb: , rebooting computer removes innodb: error. innodb: if corrupt page index page innodb: can try fix corruption innodb: dumping, dropping, , reimporting innodb: corrupt table. can use check innodb: table scan table corruption. innodb: see http://dev.mysql.com/doc/refman/5.1/en/forcing-innodb-recovery.html innodb: forcing recovery. innodb: ending processing because of corrupt database page.

mysql version:

$ mysql --version /usr/local/mysql/bin/mysql  ver 14.14 distrib 5.1.55, apple-darwin10.3.0 (i386) using readline 5.1

mysql conf file:

$ cat /etc/my.cnf  [mysqld] max_allowed_packet=128m

you can try force recovery way : how force recovery innodb or safer way try recovering table : table recovery after database page corruption hope you.


Comments

Post a Comment

Popular posts from this blog

delphi - How to convert bitmaps to video? -

-
Image
my application creates images fractals , love feeling of 'flying' around fractal. once saved 2000 bitmaps file , created avi using premiere. experience rather frustrating though succeeded in creating movie. spectacular. of course want create video application. don't care niftyness of codec, compression or whatever. want have video can replay on systems. in past have tried never succeeded. triggered question alas not ffmpeg running. update i decided adapt question , put bounty it. have seen several solutions attractive (because it's simple) seems me taviwrite. tried taviwriter did not succeed. in procedure taviwriter.write; function call around line 370 avierr := avisavev(s, // pchar(filename), nil, // file handler nil, // callback nstreams, // number of streams streams, compoptions); // compress options
Read more

jasper reports - Fixed header in Excel using JasperReports -

-
how can create excel report fixed header using japserreports? mean need header fixed when scroll excel file. this possible adding couple properties in jrxml file each report. take @ advanced excel features freeze panes. if wanted freeze after first column header (down left side basically) this: <statictext> <reportelement style="sans_bold" mode="opaque" x="0" y="60" width="104" height="20" forecolor="#ffffff" backcolor="#666666"> <property name="net.sf.jasperreports.export.xls.auto.filter" value="start"/> <property name="net.sf.jasperreports.export.xls.column.width" value="110"/> <property name="net.sf.jasperreports.export.xls.freeze.column.edge" value="left"/> </reportelement> &
Read more

python - ('The SQL contains 0 parameter markers, but 50 parameters were supplied', 'HY000') or TypeError: 'tuple' object is not callable -

-
import pyodbc,nltk,array cnxn = pyodbc.connect('driver={mysql odbc 5.1 driver};server=127.0.0.1;port=3306;database=information_schema;user=root; password=1234;option=3;') cursor = cnxn.cursor() cursor.execute("use collegedatabase ;") cursor.execute("select * sampledata ; ") cnxn.commit() s=[] j=[] x=[] words = [] w = [] sfq = [] pos=[] entry in cursor: s.append(entry.injury_type),j.append(entry.injury_desc) nltk.tokenize import punktwordtokenizer nltk.corpus import stopwords tokenizer = punktwordtokenizer() english_stops = set(stopwords.words('english')) in range(0,26): # filter stop words tokenizer.tokenize(j[i]) w.append([word word in tokenizer.tokenize(j[i]) if word not in english_stops]) in range(0 , 26):#converting tokenzied text ito string sfq.append(" ".join(w[a])) replacers import regexpreplacer replacer = regexpreplacer() in range (0,26):#pos tagging replacer.repl
Read more