My site. http://www.yoimagehost.com I understand I havent uploaded database. I can switch nameservers back to get database I just need to know how to zip it or whatever and then upload it in new server. Newb question, please dont flame me dont work with databases a lot and host is not on right now.
Hey if you have cpanel, log in and go to back up click on the database you want to back up and then go to your new host and go back into cpanel click back up and upload it, you will still have to add the sql user but that wont be to hard!
If you have access on server directly (console or ssh remote) just run: mysqldump -u username -p database > dump.sql copy the file on your new server and : mysql -u username -p database < dump.sql Regards Adrian
I dont have that access. I did the upload thing and I beelive it got there but everytime I put in the right user for database it changes it. http://img157.imageshack.us/img157/6122/databaseinfo0vm.png - Thats the old cpanel. The user is yoimage_images and it has the connection string thing(not sure what thats for) But on mine when I enter yoimage_images it changes it to yoimage_yoimagei. This is how it looks- http://img508.imageshack.us/img508/3461/databasenew4vd.png
Just go into phpMyadmin and upload the database via the "SQL" tab on it. This is recommended for small-size DB's only.
if you wanted me to go to the query window I did and i clicked import files and i click the file that is the database and then mysql says no database selected I finally just clicked te creat a user and it added the connection string crap but the user is yoimage_ my site says :"Couldn't connect to database server: Access denied for user: 'yoimage_images@localhost' (Using password: YES)"
In cpanel have you got to the MySQL Databases menu and gave the database and user permissions? You can do that buy selecting them in the drop down list and press add user to db, this will give the user permissions and should take your error away. If it doesnt do you have a user created?
Is there a way to change what username the database will accept cause right now it looking for user "yoimage_images" and every tiem i add that as a user it changes it to "yoimage_yoimagei" so i want it to look for that user instead since when i type in "yoimage_images" it changes to that.
It changes to yoimage_yoimagei or is it just yoimage_yoimage if it wont accept yoimage you can always change it in your config.php file to reflect the name you are using.
It accessed the database username but another probem, go to my site theres another kind of error that I dont understand at all. Thanks for helping so far I dont know where that crappy error is randomly coming from
does the script you are installing come with a readme? Did all of the database get backed up? Are you missing anything check carefully!
If you want to get this working still pm me your msn or aim or gtalk so I can guide you through step by step!