Re: Restore data from MySQL data files
I found that the database I was primarily interested in only had a MyISAM table (.myd and .myi file), nothing in InnoDB. So I first copied over that database directory to my other MySQL instance and restarted it. MySQL Workbench hang a bit when expanding its tree, so I dropped the database, recreated it and then copied the table in and restarted. Works fine now. I have restored the database in this way on the new server machine and the application works again. :-) Next time we'll have a more reliable backup... -- Yves Goergen LonelyPixel nospam.l...@unclassified.de Visit my web laboratory at http://beta.unclassified.de -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql
Re: Restore data from MySQL data files
Hah. I suspect the machine was running when it crashed - that is, the mysql was shut down uncleanly? You can safely ignore the mysql.plugin bit for the moment - that's for when it's booted properly. It looks like the newer InnoDB has trouble reading your ibdata file. Possible causes: * Are all the files in the right place as referenced by your my.cnf ? * Does the user the daemon run as have proper permissions to access the files? If in doubt, set the files to read/write for everyone. * Possible physical file corruption - did your old server die from a bad disk? It's also possible that the newer InnoDB recovery code is unable to properly handle the older file format. I strongly suggest to figure out what the old version was and set that up to attempt recovery, and only upgrade based off cleanly closed datafiles, with innodb_fast_shutdown set to 0 - see http://dev.mysql.com/doc/refman/5.1/en/innodb-parameters.html#sysvar_innodb_fast_shutdown for info on that. -- Bier met grenadyn Is als mosterd by den wyn Sy die't drinkt, is eene kwezel Hy die't drinkt, is ras een ezel -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
Restore data from MySQL data files
Hi, Recently a home server has crashed and would not boot anymore into Windows. We decided to replace it altogether and I managed to repair the file system more or less so that I could copy some directories from the broken disk. One of them is the MySQL data directory of that XAMPP installation. I have now set up a new computer and tried to use the old data files but the MySQL service doesn't start. The old machine was an unknown MySQL version on Windows XP, the new is running MySQL 5.5.16 on Windows 7 (32 bit). The error log is attached to this mail. It all sounds like real bugs in MySQL, at least it's standing in the file. I already ran mysql_upgrade.exe but it didn't change anything. What can I do now to restore that data? -- Yves Goergen LonelyPixel nospam.l...@unclassified.de Visit my web laboratory at http://beta.unclassified.de -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
Re: Restore data from MySQL data files
Am 09.11.2011 21:46, schrieb Yves Goergen: The old machine was an unknown MySQL version on Windows XP pfff - unknown version? how comes? The error log is attached to this mail. It all sounds like real bugs in MySQL, at least it's standing in the file there is no attachment so please CLEAR the log, try again restart and post the log here inline signature.asc Description: OpenPGP digital signature
Re: Restore data from MySQL data files
On 09.11.2011 21:58 CE(S)T, Reindl Harald wrote: Am 09.11.2011 21:46, schrieb Yves Goergen: The old machine was an unknown MySQL version on Windows XP pfff - unknown version? how comes? The old MySQL installation doesn't run anymore because the OS is gone. I could only backup the files. The error log is attached to this mail. It all sounds like real bugs in MySQL, at least it's standing in the file there is no attachment so please CLEAR the log, try again restart and post the log here inline Done, here it is: 09 22:49:59 [Note] Plugin 'FEDERATED' is disabled. c:\xampp\mysql\bin\mysqld.exe: Table 'mysql.plugin' doesn't exist 09 22:49:59 [ERROR] Can't open the mysql.plugin table. Please run mysql_upgrade to create it. (That's what I did.) 09 22:49:59 InnoDB: The InnoDB memory heap is disabled 09 22:49:59 InnoDB: Mutexes and rw_locks use Windows interlocked functions 09 22:49:59 InnoDB: Compressed tables use zlib 1.2.3 09 22:49:59 InnoDB: Initializing buffer pool, size = 16.0M 09 22:49:59 InnoDB: Completed initialization of buffer pool 09 22:49:59 InnoDB: highest supported file format is Barracuda. InnoDB: Resetting space id's in the doublewrite buffer 09 22:49:59 InnoDB: Error: trying to access tablespace 1 page no. 2, InnoDB: but the tablespace does not exist or is just being dropped. 09 22:49:59 InnoDB: Error: trying to access tablespace 1 page no. 2, InnoDB: but the tablespace does not exist or is just being dropped. 09 22:49:59 InnoDB: Error: trying to access tablespace 1 page no. 2, InnoDB: but the tablespace does not exist or is just being dropped. 09 22:49:59 InnoDB: Error: trying to access tablespace 1 page no. 2, InnoDB: but the tablespace does not exist or is just being dropped. 09 22:49:59 InnoDB: Error: trying to access tablespace 1 page no. 2, InnoDB: but the tablespace does not exist or is just being dropped. 09 22:49:59 InnoDB: Error: trying to access tablespace 1 page no. 2, InnoDB: but the tablespace does not exist or is just being dropped. 09 22:49:59 InnoDB: Error: trying to access tablespace 1 page no. 2, InnoDB: but the tablespace does not exist or is just being dropped. 09 22:49:59 InnoDB: Error: trying to access tablespace 1 page no. 2, InnoDB: but the tablespace does not exist or is just being dropped. 09 22:49:59 InnoDB: Error: trying to access tablespace 1 page no. 2, InnoDB: but the tablespace does not exist or is just being dropped. 09 22:49:59 InnoDB: Error: trying to access tablespace 1 page no. 2, InnoDB: but the tablespace does not exist or is just being dropped. 09 22:49:59 InnoDB: Error: trying to access tablespace 1 page no. 2, InnoDB: but the tablespace does not exist or is just being dropped. 09 22:49:59 InnoDB: Error: trying to access tablespace 1 page no. 2, InnoDB: but the tablespace does not exist or is just being dropped. 09 22:49:59 InnoDB: Error: trying to access tablespace 1 page no. 2, InnoDB: but the tablespace does not exist or is just being dropped. 09 22:49:59 InnoDB: Error: trying to access tablespace 1 page no. 2, InnoDB: but the tablespace does not exist or is just being dropped. 09 22:49:59 InnoDB: Error: trying to access tablespace 1 page no. 2, InnoDB: but the tablespace does not exist or is just being dropped. 09 22:49:59 InnoDB: Error: trying to access tablespace 1 page no. 2, InnoDB: but the tablespace does not exist or is just being dropped. 09 22:49:59 InnoDB: Error: trying to access tablespace 1 page no. 2, InnoDB: but the tablespace does not exist or is just being dropped. 09 22:49:59 InnoDB: Error: trying to access tablespace 1 page no. 2, InnoDB: but the tablespace does not exist or is just being dropped. 09 22:49:59 InnoDB: Error: trying to access tablespace 1 page no. 2, InnoDB: but the tablespace does not exist or is just being dropped. 09 22:49:59 InnoDB: Error: trying to access tablespace 1 page no. 2, InnoDB: but the tablespace does not exist or is just being dropped. 09 22:49:59 InnoDB: Error: trying to access tablespace 1 page no. 2, InnoDB: but the tablespace does not exist or is just being dropped. 09 22:49:59 InnoDB: Error: trying to access tablespace 1 page no. 2, InnoDB: but the tablespace does not exist or is just being dropped. 09 22:49:59 InnoDB: Error: trying to access tablespace 1 page no. 2, InnoDB: but the tablespace does not exist or is just being dropped. 09 22:49:59 InnoDB: Error: trying to access tablespace 1 page no. 2, InnoDB: but the tablespace does not exist or is just being dropped. 09 22:49:59 InnoDB: Error: trying to access tablespace 1 page no. 2, InnoDB: but the tablespace does not exist or is just being dropped. 09 22:49:59 InnoDB: Error: trying to access tablespace 1 page no. 2, InnoDB: but the tablespace does not exist or is just being dropped. 09 22:49:59 InnoDB:
Re: Store MySQL data files and log files (log bin) separated!!!
Marcos Vinícius Vieira dos Santos wrote: I used --localstatedir in ./configure but both data files and log files was stored together. In your my.cnf file, put the lines (in [mysqld] section datadir = /sgdb/data log-bin = /var/log/mysql -- raj shekhar facts: http://rajshekhar.net | opinions: http://rajshekhar.net/blog Yoda of Borg are we: Futile is resistance. Assimilate you, we will 'Borg? Sounds Swedish.' - Lily, Star Trek First Contact -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Store MySQL data files and log files (log bin) separated!!!
Hello everyone, I am compiling mysql source and need stored MySQL data files and log files (log bin) separated. For example: /var/log/mysql /* log files and /sgdb/data /* data files I used --localstatedir in ./configure but both data files and log files was stored together. How do this Thanks Marcos Santos Abra sua conta no Yahoo! Mail, o único sem limite de espaço para armazenamento! http://br.mail.yahoo.com/
Re: Mysql Data files
Hello. See: http://dev.mysql.com/doc/mysql/en/myisam-storage-engine.html http://dev.mysql.com/doc/mysql/en/using-innodb-tables.html V. Agarwal [EMAIL PROTECTED] wrote: Hi, On PC, I see *.frm files for each table while I see 3 files on Unix/Linux (*.MYD,*,MYI,*.frm). Need to know what these files are. I created a table on PC Mysql with type set to InnoDB which also created *.frm file. Any ideas ? __ Do You Yahoo!? Tired of spam? Yahoo! Mail has the best spam protection around http://mail.yahoo.com -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.NET http://www.ensita.net/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Gleb Paharenko / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.NET ___/ www.mysql.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Mysql Data files
Hi, On PC, I see *.frm files for each table while I see 3 files on Unix/Linux (*.MYD,*,MYI,*.frm). Need to know what these files are. I created a table on PC Mysql with type set to InnoDB which also created *.frm file. Any ideas ? __ Do You Yahoo!? Tired of spam? Yahoo! Mail has the best spam protection around http://mail.yahoo.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: MySQL data files
Shutdown mysql, move data files, create symlink to datafile(s) on other partition/disk/whatever.. - Original Message - From: VijayKumar Dogra [EMAIL PROTECTED] Date: Wed, 22 Sep 2004 11:22:55 +0530 Subject: MySQL data files To: [EMAIL PROTECTED] Hello All, Is there any way by which I can store data files of mysql in other partition of my system Regards, VijayKumar Dogra -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: MySQL data files
Sure you can. Just move your current data to the location you like to use and then do either of the followings: 1) supply parameter --datadir during startup (or equivalent in my.cnf file) 2) Create a symlink from old location to new location - Original Message - From: VijayKumar Dogra [EMAIL PROTECTED] Date: Wed, 22 Sep 2004 11:22:55 +0530 Subject: MySQL data files To: [EMAIL PROTECTED] Hello All, Is there any way by which I can store data files of mysql in other partition of my system Regards, VijayKumar Dogra -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
MySQL data files
Hello All, Is there any way by which I canstore data files of mysql in other partition of my system Regards, VijayKumar Dogra
Re: PCAnywhere like linux client - mysql data files administration
Jack A Fobel wrote: I remember seeing a program awhile back that acts like pcanywhere or terminal services, to connect to a linux or windows box. Anyone remember the name? Depends what you mean: a. Terminal services, or b. pcanywhere(tm) If it's (a), then you've got a wide choice of: ocommand line services, telnet, etc. (the command line mysql client is pretty good imho). oX-windows, (using the DISPLAY variable) oVNC, etc... If you're looking for a PCAnyWhere-alike, then the only one I've found is x0rfbserver, which is available at http://www.hexonet.de/software/x0rfbserver/ (not tried it myself, but I've heard it's pretty good) This should allow you to control a server, (your database one?) from many clients, (it's supposed to be compatible with the VNC clients), from PalmPilots through to PC's etc. Note that VNC gives you (unless there's been a lot of changes since I last looked at it a year ago!) a desktop on the destination machine. It doesn't give you control of a particular screen, the same way that the Windows remote control software does. Regards Bob Cross. * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * This message is confidential. It may also be privileged or protected by other legal rules. It does not constitute an offer or acceptance of an offer, nor shall it form any part of a legally binding contract. If you have received this communication in error, please let us know by reply then destroy it. You should not use, print, copy the message or disclose its contents to anyone. E-mail is subject to possible data corruption, is not secure, and its content does not necessarily represent the opinion of this Company. No representation or warranty is made as to the accuracy or completeness of the information and no liability can be accepted for any loss arising from its use. This e-mail and any attachments are not guaranteed to be free from so-called computer viruses and it is recommended that you check for such viruses before down-loading it to your computer equipment. This Company has no control over other websites to which there may be hypertext links and no liability can be accepted in relation to those sites. Scottish Newcastle plc Registered in Scotland, Registered Number 16288 Registered Office: 33, Ellersly Road, Edinburgh, EH12 6HX * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
PCAnywhere like linux client - mysql data files administration
subject: PCAnywhere like linux client - mysql data files administration Hi, I remember seeing a program awhile back that acts like pcanywhere or terminal services, to connect to a linux or windows box. Anyone remember the name? Thanks, Jack - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: PCAnywhere like linux client - mysql data files administration
i believe your talking about VNC. http://www.uk.research.att.com/vnc/ Jack A. Fobel wrote: subject: PCAnywhere like linux client - mysql data files administration Hi, I remember seeing a program awhile back that acts like pcanywhere or terminal services, to connect to a linux or windows box. Anyone remember the name? Thanks, Jack - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php -- Joe Ellis http://www.lithodyne.net - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: PCAnywhere like linux client - mysql data files administration
Hi there, this piece of software you re talking about could be VNC. You do not even need a client. If you use a java compatible browser you can use the terminal directly from your browser. Don t have the link on the hand, but if you look into a search engine you should be able to find a trace. Greetings, Gerald Ursprüngliche Nachricht Am 15.12.01, 19:49:05, schrieb Jack A. Fobel [EMAIL PROTECTED] zum Thema PCAnywhere like linux client - mysql data files administration : subject: PCAnywhere like linux client - mysql data files administration Hi, I remember seeing a program awhile back that acts like pcanywhere or terminal services, to connect to a linux or windows box. Anyone remember the name? Thanks, Jack - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: PCAnywhere like linux client - mysql data files administration
X-obligatory-filter-fodder: database,sql,query,table Joe Ellis wrote: i believe your talking about VNC. http://www.uk.research.att.com/vnc/ Jack A. Fobel wrote: I remember seeing a program awhile back that acts like pcanywhere or terminal services, to connect to a linux or windows box. Anyone remember the name? To connect to Windows machines, VNC works just like pcAnywhere (though it puts a lot more strain on the server you're connecting to if you have a lot of DOS/NT command windows open on its display - pcAnywhere does a better job with command windows). You get to see the desktop on the remote machine, and manipulate applications on it. However, when connecting to Linux and other Unix boxes, you don't get to actually see the contents of DISPLAY :0. Instead, you get a whole fresh new display (:1), on which you can start your own clients. So basically, you can interact with the system, but not with the applications running on the existing default desktop on the system. It's quicker and less CPU-intensive for the remote system for you to just telnet in to the system, instead of VNC'ing in. The only time VNC helps is if you need to run a GUI application on the target system, and you don't have an X server handy on your desktop, but do have a browser (i.e. you are on a Windows or Mac box without an X server). (PS There are free Windows-based X servers available at Tucows - http://www.tucows.com). -- Shankar. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php