Forum Replies Created
-
AuthorPosts
-
Linda
MemberThank you for explaining. I thought it might make generate some errors in the backup if the database was being written to during the backup, but if all that happens is that you miss out any changes after you start the process, then that isn't an issue.
The storage engine appears to be MyISAM.
MemberWould you recommend sticking with the default settings (which I believe are the same as are shown in my screencap), or should I select or deselect any other options? 🙂
MemberThanks for the info. 🙂
The tables for the board I was trying to backup are all MyISAM. A screenshot of the settings have been attached. I think I just left it at the default.
Edited to add: Doh, of course, I imagine that's what the 'Lock all tables for read' option does. But would it be safe to have that unchecked?
MemberThank you. 🙂
Btw, what are the advantages (and disadvantages) of using the backup option instead of the export as batch script option? Is the backup faster? Does it also lock the database to read access only?
MemberAhh, okay. Thank you. I am a bit nervous about messing something up, so I hadn't dared try that without knowing what it did. 🙂
MemberThank you. 🙂 I am pretty much a mySQL newbie, but I am guessing this is something I can't do myself but would need my host to do? If so, do I just ask the host for FILE privileges and give the instructions you mentioned in the previous post?
October 20, 2006 at 10:13 am in reply to: Error 1045 For Ssh Tunneling — Probably A Local Port Issue. #22804MemberJust after I submitted a ticket (have now closed and updated it), I saw the reference to http://webyog.com/faq/16_66_en.html in another question on the forum. Well, that solved it, as the problem was that I still had the MySQL Host Address to the address to the remove server, as I had been using before I added the SSH tunneling. Changing that to 'localhost' was what was needed.
October 20, 2006 at 9:23 am in reply to: Error 1045 For Ssh Tunneling — Probably A Local Port Issue. #22803MemberSorry, no, not literally 'mysql host address'. But it is not saying 'locahost', no. Its giving the address I put in as the ssh server and mysql server address.
Version is 5.19
October 19, 2006 at 10:51 pm in reply to: Error 1045 For Ssh Tunneling — Probably A Local Port Issue. #22801MemberYes, I can connect to the SSH via PuTTY without any problem, and from there I am able to get to the mySQL using mysql -p
and then giving the password. Edited add: The one thing I do find a bit odd is how it gives the error message, as it says access denied for user 'username'@'mysql host address', including those single quotes.
October 19, 2006 at 9:14 am in reply to: Error 1045 For Ssh Tunneling — Probably A Local Port Issue. #22799Memberpeterlaursen wrote on Oct 19 2006, 06:07 AM:I do noit think this is a firewall issue. The 1045 error is a MySQL server error, and an authentication error with mySQL (not with the SSH daemon).Are you sure that you use the MYSQL username and password on ther server tab?
I have checked and double checked the mySQL username and password, and they are exactly the same that I use with other applications that do manage to connect.
MemberI have looked at the help dialogue for Export Database As Batch Script, and what I am uncertain about even after reading that information is which options I should check, since I don't understand what each of those options will do. Even with the description of each option in the helpfile, I am not sure which I should or shouldn't check. Or can I just leave it at the default settings?
MemberYes. Is it only possible to use this option to backup from one database to another?
What do I use if I want to do an offsite backup on a machine that doesn't have mySQL? The export as a script option? If so, can I find an explanation of the different options in the export as script dialogue?
-
AuthorPosts
