[mysql] Dump table _files_ to a text file?
I have a MySQL installation that went terribly wrong so I changed to a different server, reset everything up and am up and running again. The problem is, I'm so new to this I didn't know how to move my databases, and since there wasn't much information in them (about two weeks worth of posts to a phpBB), I just started from scratch with a new database. Is there a way I can access the .FRM, .MYD. and .MYI to dump the text to a text file of some sort? Is there any easy way to use these files and import them into Access 2003? Keep in mind that these files are not part of a working MySQL install, so I need a way to work with them that is not dependent upon the MySQL installation working. Thanks! Ryan Sinnwell Regional IT Engineer The Weitz Company 515-698-4281 515-229-5517 (Cell) -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
MySQL Database Merge
I have a folder with all of the files from a database that the server shot craps (database is used for phpBB). I now have another server up and running with phpBB setup and a database with the same name. My question is, is there any way to merge the information into the new database? We had quite a few posts and attachments on the old machine that would be useful to have again. Even if there was a way to dump them to a text file so I could re-post them at my leisure, that would work as well. I can't seem to find a way to read any of the files I have, nor can I get the new server to do anything with them. I have tried using tools mentioned here on this list to connect to the old server remotely and it will not allow me, so hopefully there is something I can do with them locally on my PC. Thanks! Ryan Sinnwell Regional IT Engineer The Weitz Company 515-698-4281 515-229-5517 (Cell) -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Installation Question - RedHat 9.0
I am trying to setup Jabberd2 as a test for our IT users and have run into a few issues. Here is a link to the instructions I'm following: http://www.jabberdoc.org/app_mysql.html I know there are things missing because after I complete the make install in step A.4.6, it goes right on to have me change the root password, but mysqld isn't even running at this point. Could someone that has installed mySQL many times give these a look and see what steps they have left out that I will need for RedHat 9.0? One other step that doesn't appear to be correct is A.4.9 because /usr/local/var/mysql/ does not even exist after the install as they describe it. Also, if I want mysqld to start every time the computer is booted, and use the mysql user that I created per these instructions, is this what I would add to rc.local: /usr/local/libexec/mysqld --user=mysql Is rc.local the correct file to put this in or is there a better place? Any help that is provided will be much appreciated. Thanks! Ryan Sinnwell Regional IT Engineer The Weitz Company 515-698-4281 515-229-5517 (Cell) -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]