iGuest 3 Report post Posted December 24, 2004 Hey I got 5 days to figure this out, ok see I got my free hosting just a few days ago, and I am going to transfer my website from my paid hosting plan with a diffrent host to my free one, well I copied all of the files and php and everything except I need to somehow copy or transfer the database from my old host to my new free website I got from here, the old host I was useing has pretty much everything the same but I had to pay, so please explain to me someone how I can someone how transfer the database from my old host to this one within 5 days of this post because that is how much longer I have left before my paid host shuts my website down.PLEASE HELP Share this post Link to post Share on other sites
iGuest 3 Report post Posted December 24, 2004 I think you can backup your database by importing all tables to a notepad document... and then export to these host. (but i am not an expert on this)... and sorry for my bad english :oops: Share this post Link to post Share on other sites
iGuest 3 Report post Posted December 25, 2004 Well can you or someone please explain how to do that I am a real noob so please explain it as simple and understanding as possible. Share this post Link to post Share on other sites
iGuest 3 Report post Posted December 25, 2004 Go to your Cpanel, make back up your database in "back up' button. Or go to your phpmyadmin (old server), click to your sql database that you want to back up. click 'export' button, save as a .sql.gz file. in your new server, go to phpmyadmin, creat database name like your old ones. in that database, click to "SQL" button, browse to you sql.gz file. Share this post Link to post Share on other sites
iGuest 3 Report post Posted December 26, 2004 Well I did all of that and transferd the database and now when I got to my website I get this error Warning: mysql_connect(): Access denied for user: 'banner7@localhost' (Using password: YES) in /home/warrior/public_html/banners.php on line 3Could not connect: Access denied for user: 'banner7@localhost' (Using password: YES)here is the link to the website I am trying to transfer the site to.I am trying to transfer https://de.godaddy.com/domains/domain-name-search?ci=55119to warrior.freenukehosting.comI transfered all the files and the database but what is wrong? Share this post Link to post Share on other sites
iGuest 3 Report post Posted December 26, 2004 probably ur SQL settings... Share this post Link to post Share on other sites
iGuest 3 Report post Posted December 26, 2004 Yes! probably you don't have change the database settings (host, username and password) in your script document... Share this post Link to post Share on other sites
iGuest 3 Report post Posted December 26, 2004 well how do I change those? Share this post Link to post Share on other sites
iGuest 3 Report post Posted December 26, 2004 well I looked through the scripts and I found this, is this the file your saying I have to edit, and if so please show me a sample of how I would edit it remember I am a bit of a noob,<?// Be sure when you edit this file that you DO NOT delete the quotation marks or remove any code. Also, do not use quotations in the variables or the site will not work.$dbhost="localhost"; // probably localhost$dbname="warrior_dbban11"; // database name$dbuser="banner7"; // database username$dbpassword="zdex7713"; // database password$ratiohigh=2; // banner views$ratiolow=1; // credits given to the user for the above banner views$referral_credits=100; //banner impressions given to a referral signup$baseurl="https://de.godaddy.com/domains/domain-name-search?ci=55119%22%3b%24bannerexchangename%3d%22Banner7 Exchange";$namefrom="Banner7 Exchange";$emailfrom="kylewallace14@cox.net";$admin_password = "zdex7713"; //this is the password to your main banner site banners ////////////////////////////////////////// End Site Config //////////////////////////////////////////$passwordretrievalsubject="$bannerexchangename - password retrieval";$passwordretrievalbody="Hi _username_,As requested, your password for the $bannerexchangename is _password_Thanks$bannerexchangename team.";$welcomeemailsubject="Welcome to $bannerexchangename!";$welcomeemailbody="Hi _username_, Welcome to the $bannerexchangename, you can log in to your account at $baseurl"."login.php - your username is '_username_' and your password is '_password_'. Please click the following link to activate your account - you won't be able to log in until you have followed this link: $baseurl"."authorise.php?username=_username_&rand=_rand_You can start earning banner views now by adding the following code to your web pages<!--begin $bannerexchangename code --><iframe src=$baseurl"."display.php?id=_id_ frameborder=0 vspace=0 hspace=0 width=468 height=78 marginwidth=0 marginheight=0 scrolling=no></iframe><!-- end $bannerexchangename code -->Please note though, until you have logged into the system via the URL above, added a banner and url to your account and it has been reviewed by an admin, it won't be displayed on other member sites.Thanks for joining!$bannerexchangename staff.";//////////////////////////////////////////Don't edit anything below this point//////////////////////////////////////////function totalviews(){ global $dbhost; global $dbname; global $dbuser; global $dbpassword; $link = mysql_connect($dbhost, $dbuser, $dbpassword) or die("Could not connect: " . mysql_error()); mysql_select_db($dbname); $sSQL="select n_Value from t_Stats where s_Name="totalviews""; $results=mysql_query($sSQL); list($totalviews)=mysql_fetch_row($results); echo $totalviews;}function stripjunk($sourcestring){ $sourcestring=str_replace(""","",$sourcestring); $sourcestring=str_replace("<","",$sourcestring); $sourcestring=str_replace(">","",$sourcestring); return($sourcestring);}?> Share this post Link to post Share on other sites
iGuest 3 Report post Posted December 27, 2004 Ok nm, thanx everyone I have gotten this problem corrected and thenx everyone for the help. Share this post Link to post Share on other sites
iGuest 3 Report post Posted December 30, 2004 make sure that you modify your config.php Share this post Link to post Share on other sites
