Hi, I have recently transfered my site from a UK based Linux server to a host in another country using UNIX I think and Plesk. I find that via Plesk or FileZilla there are some directories/files that will not allow me to change the write permissions. I also find that now my Joomla site is pretty broken/corrupted. I cannot submit information to be written to the database. And a lot of information/data seems to have been lost in the transfer. Can anybody help with these problems that have occured during transfer?
The permissions issued can be resolved by using the site control's file manager to set the permissions. This will work when ftp clients won't. Unless you have a back up of your site or DB a fesh install is about all I can suggest. Edit: OOPs You can't change permissions via Plesk? What directories are you trying to change?
Im trying to change permissions on directories and files via FileZilla. As soon as I change one of the template directories inside my Joomla folder...it reverts back to the previous permissions. This directory won't allow me to upload new images into the template directory....which is bizarre as I installed the template using Joomla backend! I have a backup of the old DB, but I don't use Linux at home. I have no idea how to transfer my database from my old SQL server where the backup (or original copy of the DB is) over to my new hosts SQL database which is now localhost on the same server rather than a shared SQL server as it was previously.
One thing at a time. Use the plesk file manager to set your permissions. They should stay as you set them UNLESS you are exceeding the server config file specs. Solve that problem first. As for the database you will need to create a new one and import the data from the old one using phpmyadmin.
That's great advice. Ill have a word about the server config with my host. Can anybody outline the exact steps to take to transfer the database using phpmyadmin? i have both phpmyadmin on the old server and the new. But they are remote host linux servers...and I am using windows from here. Would that corrupt files etc transfer between the three different points?
Go to the old host and do a full dump of all the tables, save it to your local computer as a zip file. Upload it to the new DB as a zip file. Unless it is over 50 kb you should have zero problems. Do be sure to set the version compatiability mode to whichever version of mysql you have on the new server. V4 is still the most common.
OK, I logged into my old server phpmyadmin. Clicked EXPORT on the main screen and selected the name of the databased. I selected .zip format and named the file _southwestp_ (the name of my database.) This downloaded a file to my desktop which said 0kb as a .sql.zip file. Im running windows and tried to exctract it to see if the full data had been saved..and was told this was an invalid zip file (is that because of the name .sql.zip?) Im a little concerned about the file being 0kb in size! Or is there another way to make a dump of the database that I am missing. Bear in mind this is the first time I have ever used phpmyadmin! Cheers for all of your continued help everyone!
Colbyt - you're a star. My new server has hit me with what may be the problem! My old server has disabled/deactivated the linked tables. He has told me the following - "I`ve found your problem when i enter your old servers db admin(phpmyadmin) there is an error "The additional Features for working with linked Tables have been deactivated" so only half of the db is importing." and "Probably all errors are related to half-db backup. They have to give permissions (pma-user) to you for the proper db backup." And my old host are not very helpful. Do you agree this is a possible problem, and is there any way around this?
You need to click on select all tables before clicking on Download, within phpmyadmin, while exporting. Also, if you have cPanel on old server, go to backups & download the Mysql backup from there, I have no idea if Plesk has this option. If possible, download it as an SQL, instead of a zip. Let me know if this works. Thanks Ishan
I really don't know the answer. I would suspect it was your error in making the dump. Here are the steps in my words and a link at the bottom to a site with directions: login to phpmyadmin select the correct DB click on the export button make sure that all the tables are listed in the export section make sure the sql button is selected. Select compatiability from the drop down box. I usually check the boxes Add DROP TABLE and Add IF NOT EXISTS check the save file as and leave the name as it is select zipped uncheck the remember template box. click GO and save the file where you can find it. If I am changing hosts I make more than one copy "just in case". At the new site, you select a DB you have created, click on import and select the file on your computer to upload. http://fragments.turtlemeat.com/mysql-database-backup-restore-phpmyadmin.php
Check the folder/file permissions of joomla. In some cases, such as installing a component, the permissions become "nobody" instead of your username, which locks you out of editing them
I changed all files and folders to chmod 777. This didn't work. Apparently the entire problem relates to the old host disabling linked tables, and they refuse to enable them for me to take a proper backup. Looks like I will be having to start this site all from scratch! Thanks for everyone who has helped me out.