Im transfering Servers but my new one doesnt have telnet!!!What do I do?

[Stu]

Do you have CPanel?

if you do you may be able to use a cron Job. I have CPanel on one of my shared accounts but I dont have Shell access on it, by using a Cron command I can backup and restore with no problem.

create a gzip backup of your DB then upload the file using FTP to the new server. to your Home Root.

Assuming your Database backup file is called DILBERT.gz
Re-Name DILBERT and the following

USERNAME to your Database Username
PASSWORD to your Database Password
DATABASE NAME to your database name

then run the following Cron Job

gunzip DILBERT.gz ; mysql -u USERNAME -pPASSWORD DATABASE NAME < DILBERT ; rm -f DILBERT

The above command will unzip the .gz file, restore the sql database and delete the gz file [b] NOTE: the database must exist, if it doesn't create an empty one first.

I've assumed that you have shell on your present account, to make the backup. If you dont then use cron with the following command to create backup

mysqldump --opt --user=USERNAME --password=PASSWORD DATABASE_NAME | gzip > /home/YOUR_DOMAIN/DILBERT.gz

[Jucin]

We have PHPadmin and this is what happens when we try uploading it

we run an sql file to transfer data and that the phpmyadmin keeps dying on it, and when you try to browse for the file, it gives you a page cannot be displayed error....

[Brad]

I would email them and ask for SSH acess, if they wont give it to you, demand a refund and find a better host.

[Haddy]

Since they wont give you shell to your account *youll find many hosts that dont because of people who dont know how to use it screwing up their accounts* ask them to upload it for you...

Whats probably happening is its timing out when you try to upload it. Which isnt unusual for a large database....Simplist thing to do is to upload it to your webspace *the .sql file* and have them ssh it to the database...

The command is:
mysql -unewusername -pnewpassowrd newdbname < dumpeddb.sql
*Replace: "newusername, newpassword, newdbname, and dumpeddb.sql" with your info..

[iggy123]

I use an application called MySQL front -- you can get it from http://mysqlfront.sstienemann.de/
it is a cool application and as long as you know the ip address. username/password of a db it will connect to it.
It does take a while to do it --- 3hrs to enter 10million characters LOL -- But it wrks fine.
I used it to rebuild my site and it went a dream

[Erwin]

03-13-03 at 03:30 AM andera said this in Post #8
i just d/l phpmyadmin and uploading it to our server....

Won't work if the db is too big. phpmyadmin would just timeout.

The best idea here if there is not telnet/ssh would be doing it via cron - a cron job is basically a timed telnet/ssh command anyway - so run the command to download it, use your ftp client to download then upload to the new server then the other command to upload it. Mind you, telnet/ssh is essential for a lot of server optimizations.

[Stryker]

I had the same problem recently. My host refused to give me SSH access and wouldn't dump the database for me through sheer laziness. In the end I dumped it using the built-in vB backup tool in the control panel. I cleared the search index first and this cut the size of the DB in half. I managed to download a 25 meg-ish DB in one continuous stream using a 56k modem, so it can be done! phpMyAdmin was absolutely useless - it would timeout without fail long before the dump was complete. The host I moved to supports SSH so that stage of the process was made much simpler. In any case, if they hadn't offered SSH to their clients I'm sure they would have helped me out if I'd asked. Customer service is everything when you're looking for a host.

[rake]

It seems many people here consider not having shell access a tragedy as far as "i can't backup my database" goes. If i would do hosting, especially shared hosting, i would disable remote shell access or block access to vital files and remove some of the functionality. And then again - database backups can be done through a simple php script anyway.... passthru? exec? system? As a system admin, i would rather make a nice little script to do everything a shell dump does, rather than giving access to inexperienced users. But that's just me.