Joomla!
http://forum.joomla.org/

Re: Moving / Exporting Joomla's mySql DB to another host or server via phpmyadmi
http://forum.joomla.org/viewtopic.php?f=237&t=35826		 Page 1 of 11
Author:  guilliam [ Wed Nov 23, 2005 9:44 am ]
Post subject:  Re: Moving / Exporting Joomla's mySql DB to another host or server via phpmyadmi
.

instructions on how to move the files can be read here:

cronlin wrote:
To move your Mambo site from either one folder to another or one server to another, here are a few basics.


    * Copy over your files, either via ftp or SSH/command line
    * Backup and then restore your database - perhaps using phpmyadmin or SSH/command line
      (this step only needed if moving site from one server to another.
    * Edit your configuration.php file to reflect the new values. Specifically the following:
     
Quote:
      $mosConfig_user = 'joomla_joomla';
      $mosConfig_password = 'password';
      $mosConfig_db = 'joomla_joomla';
      $mosConfig_absolute_path = '/home/joomla/public_html';
      $mosConfig_live_site = 'http://www.joomla.org';
      $mosConfig_cachepath = '/your absolute path/cache';


Note: You may also need to ensure you have configured your .htaccess file in the new location.
Of course with the release of Joomla! it will no longer be $mosConfig_ but $josConfig :D


or go directly to the thread: http://forum.joomla.org/index.php/topic,5556.0.html

- g
.
Author:  Caracal [ Wed Nov 23, 2005 10:33 am ]
Post subject:  Re: Moving / Exporting Joomla's mySql DB to another host or server via phpmyadmi
Thanks guilliam

When tried to find out more information, visuals can always make it so much easier. :D
Author:  guilliam [ Wed Nov 23, 2005 10:42 am ]
Post subject:  Re: Moving / Exporting Joomla's mySql DB to another host or server via phpmyadmi
Caracal wrote:
Thanks guilliam

When tried to find out more information, visuals can always make it so much easier. :D


warmly welcome.. feel free to post if you encounter any problems in this walkthru.. will be happy to assist if i have the time :)

- g
Author:  bprof [ Sat Nov 26, 2005 8:29 pm ]
Post subject:  Re: Moving / Exporting Joomla's mySql DB to another host or server via phpmyadmi
Thanks alot for these very useful instructions.

I just have a question regarding this point:

Quote:
1. should have phpMyAdmin in both the dev site(1st site) and live site(2nd site).


I have only one site which is my live site. Can I just back up my db using the instructions you wrote, and in case of failure I just upload this file using also the instruction?
Author:  The One [ Tue Nov 29, 2005 9:45 pm ]
Post subject:  Re: Moving / Exporting Joomla's mySql DB to another host or server via phpmyadmi
Now that I got this I just upload and install joomla?
Author:  guilliam [ Wed Nov 30, 2005 8:19 am ]
Post subject:  Re: Moving / Exporting Joomla's mySql DB to another host or server via phpmyadmi
The One wrote:
Now that I got this I just upload and install joomla?


upload the joomla files. then insert the mysql db with the instruction above given.

- guilliam
Author:  The One [ Wed Nov 30, 2005 2:00 pm ]
Post subject:  Re: Moving / Exporting Joomla's mySql DB to another host or server via phpmyadmi
Tnx alot, worked perfect, that was a noob Q.
Author:  joomlearner [ Wed Nov 30, 2005 6:31 pm ]
Post subject:  Re: Moving / Exporting Joomla's mySql DB to another host or server via phpmyadmi
Hello,

Oh well thanks anyways.

Joomlearner
Author:  kovox [ Thu Dec 01, 2005 7:57 am ]
Post subject:  Re: Moving / Exporting Joomla's mySql DB to another host or server via phpmyadmi
I was able to backup and then export the database into my new one.

When I log on to the admin backend, none of the information is there.

I dont know what I am doing wrong? :(


what i did:

1. downloaded 1.0.4 joomla
2. installed joomla on server
3. made backup of old database
4. exported to new database

help! lol i've been trying to learn how to do this for months now. I dunno what I am doing wrong :(
Author:  ForestDweller [ Mon Dec 12, 2005 3:13 am ]
Post subject:  Re: Moving / Exporting Joomla's mySql DB to another host or server via phpmyadmi
I followed these instructions and received this result at the end of the last step:

Quote:
MySQL said:
#1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '�' at line 1


I thought maybe I had made a mistake somewhere along the line so I went back and did it again and got the same result.
>:(
What am I doing wrong??
Author:  veroeven [ Tue Dec 13, 2005 8:21 pm ]
Post subject:  Re: Moving / Exporting Joomla's mySql DB to another host or server via phpmyadmi
I'm trying to get my site sync'ed for the first time.

Here's what I've done and where I'm at:

1. I've got a fresh install of Joomla on a subdomain of my main site, so I can show it to a client.

2. I've imported the SQL Db.

3. I've uploaded the site's files from JSAS.

4. I've configured the configuration.php file with guilliam's instructions.

However, I am still getting: 

"This site is temporarily unavailable.
Please notify the System Administrator"

when I bring up the site.


Can anyone point me in the right area to troubleshoot? Have I given enough info for you to? If not let me know.

Thanks!

Tony
Author:  Tonie [ Tue Dec 13, 2005 8:43 pm ]
Post subject:  Re: Moving / Exporting Joomla's mySql DB to another host or server via phpmyadmi
Which number does it show with the message?

#1 = no mysql support in php
#2 = cant connect to mysql
#3 = mysql ok but cant connect to database
#4 = give up and have a beer
Author:  veroeven [ Tue Dec 13, 2005 9:01 pm ]
Post subject:  Re: Moving / Exporting Joomla's mySql DB to another host or server via phpmyadmi
Thanks for the prompt reply Tonie.


I'd like to say number 4, but alas, it is number 2. Now I know what that code is for!

I looked and found a minor typo that I fixed and resaved the config.php. but I am still getting the same error code.

I've got the $mosConfig_db = 'joomla_joomla'; as " $mosConfig_db = 'username-databaseprefix_Joomladatabasename';

So far so good?
Author:  Tonie [ Tue Dec 13, 2005 9:21 pm ]
Post subject:  Re: Moving / Exporting Joomla's mySql DB to another host or server via phpmyadmi
A thread to read is this: http://forum.joomla.org/index.php/topic,3647.0.html
Author:  guilliam [ Tue Dec 13, 2005 9:42 pm ]
Post subject:  Re: Moving / Exporting Joomla's mySql DB to another host or server via phpmyadmi
@ForestDweller,

sorry for the delay in replying,.. my email notification in the forums is not working.

to answer your question,.. youre getting that error based on the difference of mysql version. can check what version are you using from the site1 and the version on site2?

will give you further instruction if its really a version incompatibility.. its just a way of dumping the mysql from site1.

- guilliam
Author:  duukertje [ Sat Dec 17, 2005 4:59 pm ]
Post subject:  Re: Moving / Exporting Joomla's mySql DB to another host or server via phpmyadmi
I have the same problem:

MySQL said:
#1064 - You have an error in your SQL syntax.  Check the manual that corresponds to your MySQL server version for the right syntax to use near 'DEFAULT CHARSET=latin1 AUTO_INCREMENT=4' at line 19 20404.0

How can I find out which version of MySQL I or my webhoster is using?

Do I need version 5? It seems Joomla has probleems with this version.
Author:  duukertje [ Sat Dec 17, 2005 5:13 pm ]
Post subject:  Re: Moving / Exporting Joomla's mySql DB to another host or server via phpmyadmi
I found which MySQL-versions are being used (you see them when one starts phpmyadmin :P). On my local JAS MySQL 4.1.14 and on my on line website  (B-One net) version 4.0.24 is used.
Author:  Lumis [ Tue Dec 20, 2005 3:50 am ]
Post subject:  Re: Moving / Exporting Joomla's mySql DB to another host or server via phpmyadmi
Bear with me, I will waffle on for my first post - hello everybody  :P

Have just been thru this nightmare - I suggest you DO NOT use cpanel to backup an SQL database - as it often does not restore when you want it to, and it also adds strange code to the backup file. You must use phpMyAdmin as suggested above.

For example you will find it adds \ to all your hyperlinks - i.e. img src="www.mysite.com/image.jpg"  becomes img src=\"www.mysite.com/image.jpg\"

This can often be fixed by a find/replace in notepad of find: \" and replace: "
Also any single quote ' will also be altered to read \' - this is harder to replace, I just went thru and replaced it with nothing - in other words deleted it, so now some of my content now shows as youll instead of you'll

Also, because the cpanel backup function does not use the back quote ` (note this is the key next to number 1 on keyboard) - try restore the fixed database using phpMyAdmin, and everytime you get a 1064 error in syntax - you must manually fix it. I know from past experience that it does not like terms like "fulltext", "introtext" and "option"
When you get this 1064 error, read where it states the error occurs, then fix it by adding a ` backquote before and after the word.

This is very confusing, so I have placed examples below:

1064 error because of MySQL conflict (MySQL uses this word and so does not realise it should be a table)

DROP TABLE IF EXISTS mos_components;
CREATE TABLE mos_components (
  id int(11) NOT NULL auto_increment,
  name varchar(50) NOT NULL default '',
  link varchar(255) NOT NULL default '',
  menuid int(11) unsigned NOT NULL default '0',
  parent int(11) unsigned NOT NULL default '0',
  admin_menu_link varchar(255) NOT NULL default '',
  admin_menu_alt varchar(255) NOT NULL default '',
  option varchar(50) NOT NULL default '',
  ordering int(11) NOT NULL default '0',
  admin_menu_img varchar(255) NOT NULL default '',
  iscore tinyint(4) NOT NULL default '0',
  params text NOT NULL,
  PRIMARY KEY  (id)
) TYPE=MyISAM;

must be made into

DROP TABLE IF EXISTS mos_components;
CREATE TABLE mos_components (
  id int(11) NOT NULL auto_increment,
  name varchar(50) NOT NULL default '',
  link varchar(255) NOT NULL default '',
  menuid int(11) unsigned NOT NULL default '0',
  parent int(11) unsigned NOT NULL default '0',
  admin_menu_link varchar(255) NOT NULL default '',
  admin_menu_alt varchar(255) NOT NULL default '',
  `option` varchar(50) NOT NULL default '',
  ordering int(11) NOT NULL default '0',
  admin_menu_img varchar(255) NOT NULL default '',
  iscore tinyint(4) NOT NULL default '0',
  params text NOT NULL,
  PRIMARY KEY  (id)
) TYPE=MyISAM;

as well as the insert table bit below which may contain

INSERT INTO mos_components (id, name, link, menuid, parent, admin_menu_link, admin_menu_alt, option, ordering, admin_menu_img, iscore, params) VALUES (1,'Banners','',0,0,'','Banner Management','com_banners',0,'js/ThemeOffice/component.png',0,'');

so change into
INSERT INTO mos_components (id, name, link, menuid, parent, admin_menu_link, admin_menu_alt, `option`, ordering, admin_menu_img, iscore, params) VALUES (1,'Banners','',0,0,'','Banner Management','com_banners',0,'js/ThemeOffice/component.png',0,'');

For hyperlinks change this:
\"text-align: justify;\">

into this
"text-align: justify;">

and for single quotes change this:
isn\'t

into this:
isnt
Maybe you could try to use a ` backquote around the ' like isn`'`t but I wasnt prepared to try as I had one humongous database to fix and this was the least of my worries.

Once I had found all the \", \' and words that MySQL doesnt like in tables like 'option', then I could use phpMyAdmin to restore fixed database.

Thats my story...........
Author:  guilliam [ Tue Dec 20, 2005 10:36 am ]
Post subject:  Re: Moving / Exporting Joomla's mySql DB to another host or server via phpmyadmi
thank you @Lumis, your first post in the official support forums has been a very meaningful one indeed. hope to see you more around.

- g
Author:  Lumis [ Tue Dec 20, 2005 11:17 am ]
Post subject:  Re: Moving / Exporting Joomla's mySql DB to another host or server via phpmyadmi
You're most welcome  ;D
I wouldn't wish my experiences on my worst enemy  >:(
Author:  guilliam [ Tue Dec 20, 2005 11:22 am ]
Post subject:  Re: Moving / Exporting Joomla's mySql DB to another host or server via phpmyadmi
Lumis wrote:
You're most welcome  ;D
I wouldn't wish my experiences on my worst enemy  >:(


OT: i wonder what your "worst enemy" is. :)

- g
Author:  Lumis [ Tue Dec 20, 2005 11:36 am ]
Post subject:  Re: Moving / Exporting Joomla's mySql DB to another host or server via phpmyadmi
guilliam wrote:
Lumis wrote:
You're most welcome  ;D
I wouldn't wish my experiences on my worst enemy  >:(


OT: i wonder what your "worst enemy" is. :)

- g


At the moment, one of my damned business clients that used CPanel to backup his SQL databases then deleted the original database when the backup would not restore properly....
Author:  guilliam [ Tue Dec 20, 2005 11:43 am ]
Post subject:  Re: Moving / Exporting Joomla's mySql DB to another host or server via phpmyadmi
i get you. ehehhehe. okies.. thanks again.

- g
Author:  Drakosha [ Tue Jan 03, 2006 11:22 am ]
Post subject:  Re: Moving / Exporting Joomla's mySql DB to another host or server via phpmyadmi
Hi All,

I have one problem after moving site to the new host.

Once I did all steps required I got my site up on new host. I can login into administrator, see all content, manage joomla asetting etc.
I can also see home page of the site. But when I click to the any other link in menu I'm getting standard IE error
"Page cannot be found."
In address bar I have text like:
http://127.0.0.1/content/view/19/28/

In Apache error log I have message:
[Tue Jan 03 13:06:14 2006] [error] [client 127.0.0.1] File does not exist: c:/program files/easyphp1-8/www/content/view/19/28/

any ideas?

Thanks.
Author:  Drakosha [ Tue Jan 03, 2006 4:27 pm ]
Post subject:  Re: Moving / Exporting Joomla's mySql DB to another host or server via phpmyadmi
answer to my post above:
problem was related to .htaccess and Search Engine Friendly URLs option. :)
resolved.
Author:  timeforsmilin [ Sat Jan 07, 2006 5:03 pm ]
Post subject:  Re: Moving / Exporting Joomla's mySql DB to another host or server via phpmyadmi
Hello forum,

I had great difficulty restoring my db from a compressed file.  I tried sql, then csv, and always had syntax errors on the restore.  Since I only had 17 tables from Open-Realty, I exported a non-compressed sql file, and that imported perfectly using the technique shown above.  Thanks G!!
Author:  guilliam [ Sat Jan 07, 2006 5:37 pm ]
Post subject:  Re: Moving / Exporting Joomla's mySql DB to another host or server via phpmyadmi
timeforsmilin wrote:
Hello forum,

I had great difficulty restoring my db from a compressed file.  I tried sql, then csv, and always had syntax errors on the restore.  Since I only had 17 tables from Open-Realty, I exported a non-compressed sql file, and that imported perfectly using the technique shown above.  Thanks G!!


warmly welcome! PAY IT FORWARD! :)

- g
Author:  deputyjones [ Thu Jan 19, 2006 5:39 am ]
Post subject:  Re: Moving / Exporting Joomla's mySql DB to another host or server via phpmyadmi
Thanks so much for this post. Once again my Joomla questions have been answered in an easy and straight forward way! I just started using Joomla and have been hard pressed to find questions that have not previously been answered somewhere on this board (usually by guilliam). Thanks especially to guilliam and also to all the other Joomla experts!
Author:  guilliam [ Thu Jan 19, 2006 11:06 am ]
Post subject:  Re: Moving / Exporting Joomla's mySql DB to another host or server via phpmyadmi
@deputyjones, warmly welcome. PAY IT FORWARD! :)

- g
Author:  raymond [ Wed Jan 25, 2006 1:30 pm ]
Post subject:  Re: Moving / Exporting Joomla's mySql DB to another host or server via phpmyadmi
I don't know if anyone else has come up with a problem like this but it I have... it seems that phpMyAdmin is limiting uploads of these SQL files to 51Mb. I've already got a HUGE database on my local PC which is bound to get even bigger. So my question goes like this...

Is there any way around this 51Mb barrier? Also, is there a way where I don't have to rely on my browser to import the SQL file? say, using FTP or Cpanel's file explorer? Any replies on this will go a long way toward helping me.  :)
Page 1 of 11 All times are UTC
Powered by phpBB © 2000, 2002, 2005, 2007 phpBB Group
http://www.phpbb.com/