[quote=“netdcon, post:2, topic:55357”]
[quote=“andwhi27, post:1, topic:55357”]
Hello everyone, I hope you can help. I have just recently bought out my former business partner and am transfering my website to Dreamhost.[/quote]
I have uploaded all my files but am having trouble with the SQL database. I am not a technical person and thought this would be straight forward but it seems a little more complicated.[/quote]
Aint it always the case.
I have 2 database files, 1 called weddingphotography_admin.sql and the other called weddingphotography.sql [/quote]
Ok, down to biz. Do you know what program or utility was used to generate those files, and if not, usually the code that creates these will put some comments at the top of the file. Post those first few lines of the file here if you’re not sure.
Ok, the first few lines of my SQL are as follows:
– phpMyAdmin SQL Dump
– version 2.11.3
– Host: outof10-vm1.vm.melbourne.co.uk:3306
– Generation Time: Jun 01, 2011 at 02:56 PM
– Server version: 5.1.56
– PHP Version: 5.2.5
The hostname is going to be mysql.yourdomain.com (provided you’re not trying to use a subdomain which I’m gonna assume not for now). With any luck no one has already used your database or user names on the server and it should be reasonably straightforward.
Also, bad luck notwithstanding, your database .sql dumps were created with the “phpmyadmin” web tool and should be relatively simple to import once you’ve created the databases.
Which leads to step 1:
Create the databases with the names in the files you have: weddingphotography_admin and weddingphotography. You will also need to have a username/password combination for each database - the same user can be assigned to both if your web application allows for it.
If you get past that, you can do the next bit and log into the “phpMyadmin” links for the respective databases to “import” the files. After that its just a matter of making things match up to those credentials in your web application (whatever that may be) and you’re online.
Mmmmm… it looks like someone else has 1 of the database names ‘weddingphotography’. Can I change the database name or do I need to do this in a lot of different files as well?
I have created the host mysql.domainname.co.uk but it doesn’t do anything when I click phpMyAdmin.
I appreciate all your help please give more