They don't use cPanel, they use their own scripts (called netadmin) and I must say it's the nicest (and easiest to use) control panel that we've ever seen :banana:

I'm trying to move from one server to another. The server I am moving FROM doesn't have ssh access so I'll have to do it in phpmyadmin. The server I'm moving TO does not have phpmyadmin so I'll have to use the ssh method.

Can I use part 1 of the phpmyadmin tutorial and part 2 of the ssh tutorial? It's okay to combine the two like that, isn't it?

Hi,
I'm restoring my database using phpMyAdmin and I followed step 2 in the first post when attempting to restored the db. When I do this I get the following error, does anyone know why or how to fix this?

Using SSH to backup your SQL file doens't specifically compress the database, the --opt command optimizes the database and clears the overhead on each table. While it may appear to be smaller, the database is actually the same size, without the overhead.

As for Site5, they actually do use CPanel, it is simply a skinned version of CPanel which is rebranded. They have indeed added their own features, such as FlashBack and such services, however it's easy to see they still use a rebranded version of CPanel :).

Site5 still recommends you use phpAdmin to backup your databases though.....


Which brings me to my question for anyone who can help -

When phpAdmin asks for a filename template for the database backup file there is this message below:


Okay, I assume this means I can put something in the template which cause the filename to include the date/time, but I don't know what. Anyone help me with this??

Cheers. :D

That's because Flashback doesn't back up databases yet ;)

how do you find the correct path??

My previous host had ssh access, my new host doesnt, so I used the bigdump method, which seemed to have restored the mysql file on my new database, now I cant view my forums homepage (its blank) however I can log into admin cp without a problem :confused: :confused:

I'm having some issues myself...

I'm all backed up via the export function on my old server. Fine.
I have a new dedicated server. So I created the database, and user for sql.

Problems.

I don't think I'm setting up the permissions for that new user correctly... I'm using plesk to add the new database and user. Fine.

I try to restore the database via ssh, and I get:

Can't create database 'DB_Name'; database exists

Ugh... So what is the issue there? If I delete the database, and do it that way, I get the errors saying no database exists. So I feel like i'm stuck.

I know there is probably a simple answer, but I just cant find it.


Thanks in advance folks.


Carter

Ah ha.. think I found the answer...

in ssh.. on a new server... use the "-f" command to ignore the error messages.
That fixed it.

sql -f -u USERNAME -p DB_NAME < /Path_to/sql_dump_file.sql

@dj

look here:
http://www.vbulletin.com/docs/html/blank_pages

Thanks for that CBrown, it got the homepage displaying however I'm getting the following error now on the top of my forums homepage :hurt: