For the record
I tried this last night as a test
Here’s what I did, it is my hope that others find this and can try it as well, without using over bloated complicated (costly) solutionsStep 1.
UPLOAD ALL OF YOUR /sitefolder directory, do NOT ZIP THIS UP
Step 2. Place it IN a folder on your host (preferably with the same name, but not completely necessary)
Step 3. Once you confirm all files are uploaded watch this handy video on google, it helped me out a lothttp://video.google.com/videoplay?docid ... +1.5&hl=enStep 4.
Create a NEW BLANK sql database on your host; make sure you assign a username with permissions to this database, before proceeding
Take your mysql dump (the file created, or also you may open that file and PASTE the contents DIRECTLY into the "mysql" tab in your phpmyadmin on your HOST (not local) once you execute the import you’ll get the "query successful records added or something, could be different depending on your install)
Step 6. This part was tricky, we all want to immediately go to the homepage but DONT, that’s a mistake, and you need to do a few more things,
First open up the configuration.php from your local site, and then download the configuration.php from your newly uploaded site, make sure the following is correct.(NOTE: this is why most db transfers fail to connect, and we all hate that)var $user = 'THIS MUST BE THE USERNAME YOU MADE FOR THE NEW SQL NOT THE LOCAL ONE';
var $password = 'NEW PASSWORD NOT LOCAL ONE';
var $db = 'FULL MYSQL NAME FOR YOUR HOSTED DB, SOMETIMES HOSTS ADD SOMETHING SO CHECK THIS CAREFULLY';
var $log_path = 'COMPLETE SERVER PATH TO THIS FOLDER/logs';
var $tmp_path = 'COMPLETE SERVER PATH TO THIS FOLDER/tmp';
REUPLOAD the configuration.php after you save it to your folder where your files reside.
Enter your sitename/folder and hopefully you’ll be all set
(Please Note: I was totally shocked when this all worked, after all the fussing I had to do with those "awesome components, paid or unpaid," I will admit it is some work, but it has always been true if we do it ourselves it gets done right RIGHT
, if it fails I tried to help, im not a coder, it worked for me, will it work for you I don’t know, one thing I do know, if it does not work I will remain subscribed to this topic and help EVERYONE who requests it for as long as I can, I for one don’t think a forum should be a place filled with "0" reply posts, this is open source, and collaboration is the heart of that, lets work together, a reminder to all of us, lets help those who were new, remember when we were new, we didn’t even know what template_css.css was, lol
Long nights later we know a lot, its TIME TO START SHARING IT
Ive said my piece, good luck on your backups and restores, btw if you continue to change your local site, updating after that is probably a lot easier, you just have to reupload the db over that one once your set, feel free to explore all components/modules and if they work go for it, if not come here try what I did, lets see if we can find out what works best, one things for sure, this procedure will not be "revised" or "bug fixed" since we are the ones doing it right?
Whats Wrong With It? All I Did Was Change That One Line Of Code!