phildemarco Posted March 18, 2006 Posted March 18, 2006 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 :'(
mtechama Posted March 18, 2006 Posted March 18, 2006 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!
phildemarco Posted March 18, 2006 Author Posted March 18, 2006 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!!!!!!!!!!!!! :(
Guest Posted March 18, 2006 Posted March 18, 2006 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 :-)
phildemarco Posted March 18, 2006 Author Posted March 18, 2006 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:
phildemarco Posted March 19, 2006 Author Posted March 19, 2006 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 :'(
Guest Posted March 20, 2006 Posted March 20, 2006 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
Recommended Posts
Archived
This topic is now archived and is closed to further replies.