Migrating from XAPP to the server

[barachini]

Dear All,

I am now finished with my page - CMS worked very well under XAMPP. For several reasons I dont want to work on a server. I rather would like to make and modify my page locally on the PC under XP with XAMPP and then do the absolut minimum steps for hosting. I am using WinSPC so that I can copy local files to the server and vice versa - thats all I am allowed to do.

I read the "copy_To_a_New_Server" section. Probable in my case this is the right thing to do? Copying the complete local directory cmsmadesimple/* and its content to the root and afterwards modifying the config.php file (modifying database setting and path).

My problem is the 3rd. step and the 5th one where the following is required "mysqldump -uUSER -hHOST -pDATABASE < dump.sql".
On the PC under XP in the cmd window I cannot use that command because only DOS commands allowed. Is there another way to transfer this database - or will it suffice to copy all files under mysql directory to the server? Since my homepage is simpl I didnt use the database at all.

THX Franz 


 

[Nullig]

You can use phpMyAdmin to do a db dump, which you can then import to your new site - you can't just copy the mysql files to the server.

Or, you could just copy the CMSMS software to the new server, reinstall and copy and paste your template, stylesheet and content info to the new host.

Nullig

[CWebguy]

XAMP may have a command line, I know WAMP does.  Easiest way is through PHPMyadmin like Nullig said.  Click on Export option.  Do a search for backing up Wordpress http://codex.wordpress.org/Backing_Up_Your_Database & http://codex.wordpress.org/Restoring_Yo ... rom_Backup .  Works the same way (and I guess the settings are the same?).

Hope this helps!

[baresi]

mysqldump is included in XAMPP (C:\Program Files\xampp\mysql\bin) and you can make it work via Windows too, check this for example http://www.apachefriends.org/f/viewtopi ... =mysqldump

[barachini]

Thanks to All - will try Nulligs second proposal reinstallation on host and then just overwriting the style, content (image and uploads) files. Am I correct that this will be less error prone since in this case I would need no extra config editing, no filename change and no explict Db dump manipulation ?

Since on the long run only the content of the news section will change I would than have to overwrite only the content directory whenever a change is required, right?
Franz 

[Dr.CSS]

If you install on host, being that you will have a DB already set up, then you can upload/FTP all the other files you need from XAMPP and import the DB from your XAMPP/phpmyadmin and you have the same site...

[barachini]

Dear Nullig (hopefully) last question from Europe to Arizona,

I had a look to some php files - there are local filenames in some of them - since I am not familiar with php - who is modifying
these local filenames ?

For my homepage I input some images, some uploads, I did some content and I modified an already existing stylesheet. Is it correct that in this case
I would only have to copy (overwrite) the following :

cmsmadesimple\tmp\templates_c  ..... here is all content and here are all stylesheets ?
cmsmadesimple\uplodas ...... all files access to
cmsmadesimple\images  ..... added images

or is it better to copy the complete cmsmadesimple\*  directory except the config because config has been generated during
setup and contains the correct file and db access?

Franz

[Dr.CSS]

Copy those and you get hosed site, as they have path info in them...

I would copy all folders/files from xampp, remember to clear site cache before, to host and add install from package...

Export DB from xampp, import to host DB, I always have to make one then fill it with import, then you can change config.php to new paths...

Most times at this point it's easier to run /install and add all info and when you get to DB page DON'T CREATE TABLES OR DEFAULT INFO uncheck those 2 tick boxes...

[barachini]

Just to be sure that I understood - you proposed the following:

1. Do a normal installation via ssh on the server (via installation shell).

2. export local database

3. cd to ../cmsmadesimple (on the server)

4. import database

5. DELETE ALL FILES on the server under the directory ./cmsmadesinple except the config file  ??

6. Copy directory including all  files from local machine .. \xamp\htdocs\cmsmadesimple to server ../cmsmadesinple except the config file??

7. do all the chmod 777 on tmp;tmp/templates_c;tmp/cache;uploads;uploads/images;/modulers

IM NOT SURE IF STEP 5 NECESSARY OR IS IT A WRONG  ONE ? Clearing cache means deleting the file in cmsmadesimple/tmp/cache right ?
FRANZ