I'd like to do a mysql dump, so I can leave my crappy host, Hostway. I've signed up with VO, but due to their server move, my acct. isn't quite operational yet. But anyway...I need help with using telnet. I've downloaded putty, and can only access hostway through ssh. I've never used telnet at all..and have no idea how to get to the "root directory" to even start the mysqldump. Can someone tell me in baby steps how to do it?
Thanks for the help!
Brooke
I did the backup using vbulletin just to see if it would be complete or not. I have that file in /public_html/backup2.sql on the new server.
Now I'm trying to put that file in my mysql database. Here's the command I'm using:
mysql -uthereeft_thereef -p******** thereeft_board < /public_html/backup2.sql
I get /public_html/backup2.sql no directory found.
Ugh. There has to be an easy way to learn this! Can anyone suggest anything??
NEEDSCRIPTS :: Solace MUD/Telnet Proxy Client Resource at Need Scripts::
that allows your telnet client to connect to the MUDs or any other server through a telnet protocol. It acts like We at Need Scripts, help You For
http://www.needscripts.com/Resource/1018.htmlHOME |
usernames and databases are setup. i guess i'm not directing it quite the right way to that .sql file.
Help please!
Telnet Alternatives - Web Hosting Help::
Innovative tools for managing your files, folders. scripts and databases without the need for Telnet. Help & Support. Contact FastVirtual
http://www.fastvirtual.com/support/cgi/telnet.htmlHOME |
I need help with tcl - The Tcl programming language::
I need help with tcl - The Tcl programming language - Tcl Need help in looping expect. Telnet after ssh. Expect question - send commands to an xterm shell
http://www.wellho.net/forum/The-Tcl-programming-language/I-need-help-with-tcl.htmlHOME |
Brooke
Brooke,
It might be best to fill out an official support request here:
http://www.vbulletin.com/members/support.php
Be sure to include the login info for both your old and new servers and for your Admin CP as well.
It looks like you have a bad backup. It's one of the reasons I don't use the backup feature in the Admin CP. Mysqldump is much more reliable.
How do I FTP using telnet in ASCII mode??
Even after moving the file in ASCII through WS-FTP I still get the same errors. So far vbulletin help hasn't solved the problem either. Is the problem with the dump file? The way I'm moving it what??? I've spent almost 10 hours trying to do this. Can someone please help??
Brooke
assuming you can log into your site via putty in SSH telnet
once logged in to backup /dump your forum database
type
mysqldump --opt -u mysqlusername -p vbdatabasename > /home/siteusername/backup.sql
where mysqlusername is the username you created in cpanel's mysql module it will be in the format (for cpanel only based hosts)
siteusername_mysqlusername
and vbdatabasename is the name of the mysql database you created in mysql cpanel modul in the format
siteusername_databasename
and /home/siteusername/backup.sql will be the location where you tell mysqldump to output your backup.sql
UNIX for Dummies Questions & Answers [Archive] - Page 11 - The UNIX and ::
Need help in choosing Unix Platform. absolute beginner with suse need help with Telnet/Exceed. PRNG is not seeded. Iterator help needed. mail or
http://www.unix.com/unix/linux/f-2-p-11.htmlHOME |
to restore/reimport a back into an empty database you type
mysql -u mysqlusername -p emptydatabasename < /home/siteusername/backup.sql
both commands will prompt you for your mysqlusername's password and will take a few minutes to complete the function depending on how large your database is
I checked my old site last night and it did seem that my host was able to make a backup file. I was actually able to ftp it over the my new site through telnet (miracles do happen :) ). But, unfortunately, it still has error messages in my sql syntax and would not load on my new database.
So, my plan today is to close my board down, see if I am able to make a backup through telnet. If not, call my host to do it (though they are saying they don't support mysql..blah, blah, blah). What if I'm unable to get a copy that doesn't have errors?? What causes these errors?
Thanks again for the help. I really hope I can get my site moved!
So far this is my only complaint about vbulletin. This process needs to be simplified.
Brooke
Originally posted by Brooke
I did the backup using vbulletin just to see if it would be complete or not. I have that file in /public_html/backup2.sql on the new server.
Now I'm trying to put that file in my mysql database. Here's the command I'm using:
mysql -uthereeft_thereef -p******** thereeft_board < /public_html/backup2.sql
I get /public_html/backup2.sql no directory found.
Ugh. There has to be an easy way to learn this! Can anyone suggest anything??
usernames and databases are setup. i guess i'm not directing it quite the right way to that .sql file.
Help please!
Brooke hmmmm the above commands in telnet should of worked.. let us know what you host says about what i outlined originally
as to your problem you sure the path doesn't look like
/home/username/public_html
etc
ask your web host or look at their faq/online support to see the full paths
Isn't it highly unlikely that there's a '/public_html' directory? After all, this would be right off the root directory and I've never seen this in any installation of Unix/Linux.
Anyway it looks like dropping the / worked, except that there was a problem on line 1652 of the backup.
thanks eva-
i needed a /usr/local/mysql/bin in front of all that to get it to work. i did the command and the file came over as 0 bytes. hmmmmm not good. Hostway is looking into it...though I dont think they will be a super help. I'm gonna try to use vb's backup and see where I get till hostway gets back to me. They said it might be some tracer problem?!?
Thanks for the help though
Brooke
Thanks Steve-
Without the '/' I get this error message:
ERROR 1064 at line 1652: You have an error in your SQL syntax near '
warning : mysql was unable to save result set in .......
hmmmm...this sucks. Any more ideas?
Thanks
Originally posted by Brooke
I get /public_html/backup2.sql no directory found.
As the message suggests, that directory doesn't exist. Try not including the '/' in front of 'public_html'. This Otherwise find the exact and complete path of the directory that contains backup2.sql and use that. In Unix/Linux you can go to this directory and type 'pwd' to find this out.
Which backup did you use? As I said before, it looks like the previous backup was bad.
 Where's The Advantage In Windows Genuine Advantage?
 Stocks Bounce After S&P Joins Bear Market |
