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 :'(
Guest Posted March 18, 2006 Posted March 18, 2006 You need to recreate you database (empty), then using cpanle, navigate to sql management, set up a user which has access to the db, then go into phpMyAdmin, click into the new database. Once there, there is a tab at the top which says "SQL" - click this, use the upload a file option, click browse, find your file, then click go, and you are away. If your backup is too large you may have issues using this method, if this is the case, and you have ssh access, then you can use: mysql -u USERNAME -p newdbname < /path/to/new/dump.sql to locate the file saved on your server and restore it. If you dont have this, you could always try asking your nice hosting people of they would do it for you...?
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 19, 2006 Posted March 19, 2006 in cpanel, go to your sql screen, and add the user from your old database to your new database, then you'll be set!
Recommended Posts
Archived
This topic is now archived and is closed to further replies.