CPanel

  • Jimmie
  • Graduate
  • Graduate
  • User avatar
  • Posts: 187
  • Loc: Ft Worth TX

Post 3+ Months Ago

Hey guys, just picked up a new server, P4 2Ghz, 512RAM, 80Gb Harddrive, 700GB Bandwidth!

I am needing some help tho. I have MySQL databases and a few other scripts, thats it VERY important that I get trasnfered over without losing any of the info. Can someone offer some insight on how I can get this done? The site transfer tool in CPanel keeps "freezing" in the middle of the process.

Thanks In Advance!
  • Anonymous
  • Bot
  • No Avatar
  • Posts: ?
  • Loc: Ozzuland
  • Status: Online

Post 3+ Months Ago

  • b_heyer
  • Web Master
  • Web Master
  • User avatar
  • Posts: 4581
  • Loc: Maryland

Post 3+ Months Ago

You might be able to do it straight from the console, if CPanel has some explanation of what its doing, just log into mysql and run the command there...
  • b_heyer
  • Web Master
  • Web Master
  • User avatar
  • Posts: 4581
  • Loc: Maryland

Post 3+ Months Ago

Actaully just go here and follow the instructions:
http://www.mysql.com/documentation/mysq ... tml#Backup
  • Jimmie
  • Graduate
  • Graduate
  • User avatar
  • Posts: 187
  • Loc: Ft Worth TX

Post 3+ Months Ago

Ok, I am in the phpmyadmin, and dont see the option to "import" a database...
  • Jimmie
  • Graduate
  • Graduate
  • User avatar
  • Posts: 187
  • Loc: Ft Worth TX

Post 3+ Months Ago

also, after I created the database in cpanel, i get these errors:

Connection Strings
Perl $dbh = DBI->connect("DBI:mysql:easyj_sexualbikini:localhost","easyj_jimmie","<PASSWORD HERE>");
PHP $dbh=mysql_connect ("localhost", "easyj_jimmie", "<PASSWORD HERE>") or die ('I cannot connect to the database because: ' . mysql_error());
mysql_select_db ("easyj_sexualbikini");

maybe thats why I cant import a database.

man, this is confusing me...
  • Bigwebmaster
  • Site Admin
  • Site Admin
  • User avatar
  • Posts: 9090
  • Loc: Seattle, WA & Phoenix, AZ

Post 3+ Months Ago

Not sure how that is an error, that is just code. Did you forget to paste the error message that goes with that code above?

Also make sure your MySQL is on.

To import a database its simple. Click on the table you wish to import into. Then goto where it says:

Run SQL query/queries on database blahblah_table

and you will see a textarea below that. Now right below that you will see something else which says:

Or Location of the textfile :

Click on browse and find the database you had exported earlier from your old host, and then click GO and that should import it.
  • b_heyer
  • Web Master
  • Web Master
  • User avatar
  • Posts: 4581
  • Loc: Maryland

Post 3+ Months Ago

The backup file you made earlier is simply a bunch of mysql queries that need to be run as bigwebmaster stated.
  • Jimmie
  • Graduate
  • Graduate
  • User avatar
  • Posts: 187
  • Loc: Ft Worth TX

Post 3+ Months Ago

OK, i figured it out.... i was thinking the "connection strings" was an error, but its not....

the phpmyadmin thing had me a little confused cause I never messed with moving databases before! all is well now, CPANEL kicks ass!

thanks for your assistance, fellas!
  • JS7
  • Newbie
  • Newbie
  • User avatar
  • Posts: 13

Post 3+ Months Ago

Quote:
Hey guys, just picked up a new server, P4 2Ghz, 512RAM, 80Gb Harddrive, 700GB Bandwidth!


Just curious... Why not get a 1GB RAM server or better? 512MB is not a whole lot. And 1GB of RAM doesn't cost much more, either... :?

Post Information

  • Total Posts in this topic: 9 posts
  • Users browsing this forum: No registered users and 10 guests
  • You cannot post new topics in this forum
  • You cannot reply to topics in this forum
  • You cannot edit your posts in this forum
  • You cannot delete your posts in this forum
  • You cannot post attachments in this forum
 
 

© 1998-2014. Ozzu® is a registered trademark of Unmelted, LLC.