Jump to content
  • Checkout
  • Login
  • Get in touch

osCommerce

The e-commerce.

MYSQL Data Base


phildemarco

Recommended Posts

Posted

Can someone Please help me out of this mess? I did make a full server backup of MSQL Data Base and saved it to my hard drive also there is a backup zip file on my Cpanel in (file manager) I just have no idea on how to re-install my data base back to my last backup.How do you upload backup data base and install on server? Thanks so much in advance for your help.

 

Phil :'(

Posted

here is a good way got to your Admin>Tools>Database Back Up then click on Restore

Wade Morris

Amarillo, Texas

 

Before you do any changes on your site you need to do BACKUP! BACKUP!

Posted
here is a good way got to your Admin>Tools>Database Back Up then click on Restore

 

Wade,

 

Thank you for you response but I can not go to my admin backup because I have no Data base on my server my store and admin are not coming up at all Totally screwed up this is what I get when I try to log in.

 

 

Warning: mysql_connect() [function.mysql-connect]: Access denied for user 'pd1pd2_osc1'@'localhost' (using password: YES) in /home/pd1pd2/public_html/includes/functions/database.php on line 19

Unable to connect to database server!

 

Anyone eles PLEASE!!!!!!!!!!!!! :(

Posted

You could unzip your Backup file, and copy the SQL Text ,

Then login to your hosting and go to SQL> PhPmySQL

 

If your DB login and PW are still their then just paste the DB Dump in to the empty database thats their paste the SQL file in PhPmySQL>pd1pd2_osc1>SQL you should see a text box that allows you to run sql queires

 

if its missing just set up the Data base again with the same Logins and PW as before then you can paste the SQL file in PhPmySQL>pd1pd2_osc1>SQL you should see a text box that allows you to run sql queires

 

The above is based on you using cpanel with PhPmySQL if your hosting is different then you might be better asking your host for some help

 

I asume this way will work for you since i do it all the time when testing and backing up and i have yet to have any problems with it. but thats not to say that OSC gurus are turning in there graves at the thought of it :-)

Posted
You could unzip your Backup file, and copy the SQL Text ,

Then login to your hosting and go to SQL> PhPmySQL

 

If your DB login and PW are still their then just paste the DB Dump in to the empty database thats their paste the SQL file in PhPmySQL>pd1pd2_osc1>SQL you should see a text box that allows you to run sql queires

 

if its missing just set up the Data base again with the same Logins and PW as before then you can paste the SQL file in PhPmySQL>pd1pd2_osc1>SQL you should see a text box that allows you to run sql queires

 

The above is based on you using cpanel with PhPmySQL if your hosting is different then you might be better asking your host for some help

 

I asume this way will work for you since i do it all the time when testing and backing up and i have yet to have any problems with it. but thats not to say that OSC gurus are turning in there graves at the thought of it :-)

 

Nigel

Thank you for your reply in my Cpanel I have MYSQL an myPHPAdmin no PhpmySQL is admin the same thing? Thanks

Phil

:wacko:

Posted

I tried to see if I could upload my data from my backup files from my hard drive and create another data base pd1pd2_osc1 well the data base is now showing up in myPhp Admin with all the files showing the only thing is when I check MSQL data base the connection strings for Php and Perl are not showing up like the other data base that was created so my store is still not working I can not access anything.This is the error I get when I try to access my store.

 

Warning: mysql_connect() [function.mysql-connect]: Access denied for user 'pd1pd2_osc1'@'localhost' (using password: YES) in /home/pd1pd2/public_html/includes/functions/database.php on line 19

Unable to connect to database server!

 

This is what is showing in mySQL data base

 

 

 

Existing MySQL Databases

 

pd1pd2_osc1

 

 

pd1pd2_phpb1

 

 

Users in phpb1

 

pd1pd2_osc1 (Privileges: ALL PRIVILEGES)

 

Connection Strings

 

Perl $dbh = DBI->connect("DBI:mysql:pd1pd2_phpb1:localhost","pd1pd2_osc1","<PASSWORD HERE>");

 

PHP $dbh=mysql_connect ("localhost", "pd1pd2_osc1", "<PASSWORD HERE>") or die ('I cannot connect to the database because: ' . mysql_error());

 

mysql_select_db ("pd1pd2_phpb1");

 

 

 

As you can see connection strings missing for pd1pd2_osc1 hope you can help me out with this I am really desperate and have no one else to turn to and my whole business is at a stand still.Thanks for all your help

 

Phil

:'(

Posted

My SQL knolage is enough to get me by but i am by no means a expert so i dont wish to start sounding like one :-) someone else that knows their SQL might be able to point you in the right direction on this

 

 

As a realy quick fix you could ask your host if they have a back up they should or their data center should have a back up of your site from the last few weeks, and they can normaly reload the SQL part and or the whole site it may be worth just contacting them sooner rather than latter since they normaly only hold for a few weeks before updating with the next

Archived

This topic is now archived and is closed to further replies.

×
×
  • Create New...