Joomla! Discussion Forums

@raymond, 2 options i can think of:

1. break up your uploads of dump into per tables. or one table at a time.. if lets say; one table is already 50mb.. so dump that table then do that same thing with others. you can make just particular dumps of a table correct? then then can be a solution.

2. use another mysql db application to directly edit the tables and db's you got on remote.. i use navicat(its commercial application though) for organizing HUGE db's.. just search google for it.

- g

Thanks gulliam! I've looked it up and it looks ok. I've found two other solutions while googling.
It seems you can set the maximum size of the DB using some phpMyAdmin config settings. Its on their site's faqs.
Also, there's BigDump which can be found at http://www.ozerov.de/bigdump.php. With this, you're supposed to upload the .gz SQL file and the bigdump.php files onto your webserver and then run go to the bigdump webpage. It seems to load the data incrementally from the website itself. Don't know if it works but I'll post my experiences when I hit the 52Mb barrier. Its supposed to raise your webserver's processing load, though. That might be a problem if your webserver complains 

Again, thanks for the tips! This is really a great community. No wonder open source continues to develop despite the lack of megabucks like, say, that other guy from Redmond. 

@raymond,.. great to hear you found that bigdump. havent tried it yet.. but may try it soon as an alternative to my ways of dumping big chunks of db.

SECOND, yes OPEN SOURCE will always be here for you and the community. its the people like YOU who make this community a reality. :)

BOTTOM LINE-> dont wonder why joomla forums has 20,000 members in less than 6 months amd still getting stronger each day.

- g

I am about to post my site, developed locally with JSAS, to my server, http://www.1and1.com - can I do that through Joomla itself if I have the logon of my server? This is all a test and not critical or live site. Reference to a tutorial would be lovely - I am so new to CMS and Joomla that it is scary and I probably have no business doing it, except I run sites for about 10 nonprofits and would LOVE to have a better way of managing them. A nice step by step, tutorial would be great. I am using Windows XP, JSAS 1.0.3, and Joomla 1.0.7 (upgraded).

check this one for reference for JSAS --> http://forum.joomla.org/index.php/topic,32577.0.html

ask your particular question on that thread since youre both using JSAS.

- g

Hello,

I am getting the dreaded number 2 error. the server is split into 2 different servers. a mysql sever and a web app server. I can connect to the DBl fine via its external IP. however, when using the same information in joomla i get no connection.

is there more testing i can be doing?

I tried connecting to the sql via the mysql command interface on the web app server. however im not sure if i had the syntax correct. i'm still a newbie.

--edit-- i should say that i have changed my configuration.php file for the new setup
here are the fields i changed

$mosConfig_user = 'j_user';
$mosConfig_password = 'password';
$mosConfig_host = '*.*.*.48'; -- set to the local address
$mosConfig_db = 'j_database';

did i miss anything?

$mosConfig_host -> its usually 'localhost' ;)

additionally check the values of the following:

$mosConfig_cachepath -> not very impt however its usually the absolute path followed by '/cache'
$mosConfig_absolute_path -> the path where the joomla index.php or the joomla folder is located
$mosConfig_db -> the name of the db
$mosConfig_dbprefix  --> usually 'jos_' however if migrated from mambo its value is 'mos'
$mosConfig_live_site -> the URL in which the joomla site is viewable in the browser
$mosConfig_user  --> user name you use to connect to the db.

you may want to check this quickie file to resolve the absolute path if youre lost figuring what youre absolute path is:

http://forum.joomla.org/index.php/topic ... #msg185563

dl the zip file i attached on that thread.

- g 

$mosConfig_user  --> user name you use to connect to the db. DO YOU MEAN THE HOST USER, DON'T YOU ? NOT THE JOOMLA ADMIN USER 
$mosConfig_password = 'password'; SAME AS BEFORE, RIGHT ?!
$mosConfig_db -> the name of the db
$mosConfig_absolute_path -> the path where the joomla index.php or the joomla folder is located FOUND USING YOUR INFO.PHP SCRIPT
$mosConfig_live_site -> the URL in which the joomla site is viewable in the browser IS IT MY DOMAIN, ISN'T IT?
$mosConfig_cachepath -> not very impt however its usually the absolute path followed by '/cache' DON'T KNOWING I JUST ADD /cache AT THE END OF THE ABSOLUTE PATH

WHAT IS ? :
$mosConfig_host = '*.*.*.48'; -- set to the local address

IS THERE OTHER TO KNOW TO CHANGE IN CONFIG.PHP ?

AND, PLEASE, AFTER MOVED FROM LOCAL TO REMOTE, WHICH IS THE BEST SISTEM TO WORK ?
WORK IN LOCAL AND UPGRADE REMOTE ? HOW DO IT ?

Many Thanks 

mumble mumble ...

I tried the Dump following guilliam instructions:

Loalhost:                    Remote
Easy PHP 1.8.01         
PHP 4.3.10                4.4.1
mySQL 4.1.9              4.0.25
PhpMyAdmin 2.6.1      2.6.4 pl2

(hoping I been able to check right)

Importing database I have back this message:
#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 37

What am I missing   

$mosConfig_host -> its the path to where the web app to be pointed. in which this is "typically" valued as 'localhost' in which localhost is the defualt address to point to the same box/computer/server/host or in lay man's term localhost is to point to its SELF. co-value of this is 127.0.0.1 which is a "loopback address". you might be wondering why is this a variable in the configuration.php of joomla? well.. since Joomla is aimed to be cross platform and cross compatible with host/server environments it is made to a variable since NOT all servers/host are a like. another reason is for MULTI and CROSS install of joomla to another box(networked) in which the database server is separated from the file server(however this is more advance install and barely happens to newbies ;) ).


2. IS THERE OTHER TO KNOW TO CHANGE IN CONFIG.PHP? -> its basically what i pointed out are the important things to check and double check, others can be changed in the global config in the joomla admin once you logged in.

3.  AND, PLEASE, AFTER MOVED FROM LOCAL TO REMOTE, WHICH IS THE BEST SISTEM TO WORK ? -> i dont understand what oyu mean by SYSTEM?

4. WORK IN LOCAL AND UPGRADE REMOTE ? HOW DO IT ? -> you may want to check the thread here -> http://forum.joomla.org/index.php/topic,36488.0.html

btw.. refrain from using all caps(ALL CAPITAL LETTERS )

- g

try this(almost 100% failsafe to bypass that charset and encoding issue, also bypassing the mysql version issue) :



- g

Many Thanks for information, ok step by step 

configuration.php done  In fact now if you go to http://www.doctorlife.org you can see message "3" (DB not imported yet)

System: (Sorry for my bad English) I mean the best "how to do"

I'll take a look to the link and let you know there 

Sorry for all capital letters

Please, Could you give me more details for import DB, I understand the concept, but ... I'm really not sure on what you told me, in special I don't understand export copy and how to run the dump 

Many Thanks 

If I understood:

from 1st DB I export it without compression and a text file is shown, I copied

to 2nd DB I entried into SQL then I past all text into "RUN SQL Query"

Same error:
#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 37

What I can do  ... 

May be try selecting a compatibility during SQL export ?
Please help me 

Here :
http://forum.joomla.org/index.php/topic ... #msg182934

I found a similar instructions with:
8 ) In the box for "Structure" check the boxes for "Add DROP TABLE" AND "Add IF NOT EXISTS".

but result don't change:
#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

Question:
Coping, have I to copy also the header text export ? :

-- phpMyAdmin SQL Dump
-- version 2.6.1
-- http://www.phpmyadmin.net
--
-- Host: localhost
-- Generato il: 08 Feb, 2006 at 01:01 PM
-- Versione MySQL: 4.1.9
-- Versione PHP: 4.3.10
--
-- Database: `doctorlife`
--

-- --------------------------------------------------------

make a new/blank mysql db.

if still no go,.. try playing with the character set of the new mysql db. set it to latin1
2nd, in your site1 uncheck/check those options regarding version etc..

im like shooting now where here ehhehe. can you post whats the mysql version of your site1 and site2? so i will have an idea what to do.

- g

okay were almost there.. (I HOPE :)) i got the version of site one -> Versione MySQL: 4.1.9
whats the mysql version of site 2?

- g

Waiting your suggestion 

Ok,
I made some trials and selcting: MySQL 40 Compatibility during export I done dump, no errors during import

But message in http://www.doctorlife.org don't change : This site is temporarily unavailable. Please notify the System Administrator "3"
May be I forget something 

Also, may be is different if I select the two boxes as expained here  :
http://forum.joomla.org/index.php/topic ... #msg182934
8 ) In the box for "Structure" check the boxes for "Add DROP TABLE" AND "Add IF NOT EXISTS".

oh thats a good sign.. so your prob now is only "3" it means:

Error 3 = FATAL ERROR: Database not found

check the name of the db in your configuration.php

- g

that was !

I'm so stupid don't thinking creating sql DB username was been added as DB nome. Solved ! MANY THANKS 

But: what is better for export select or not select these during export:

""""In the box for "Structure" check the boxes for "Add DROP TABLE" AND "Add IF NOT EXISTS" """

or, leave as default 

I checked that link but I haven't found nothing about ... 
What do you suggest me to work properly having an online site and the same in local ?
Is there an easy and quickly solution to work in local and upgrade the live site ?

its not actually called upgrade but MIGRATE to another host/server.

this is the easiest..

can you give us again what are the probs youre encountering?

- g

Sorry Guilliam,
I'm been confused posting, so

1_site is running, all seem ok -> http://www.doctorlife.org (right now is down)

2_only a question because I found here around forums a suggestment to select these during DB export (dump):
""""In the box for "Structure" check the boxes for "Add DROP TABLE" AND "Add IF NOT EXISTS" """
is it better select or not ?

3_about Migrate: What I mean is that now I built my site in local and I have put it on-line, but, right now, when I want add components, add contents and/or try something ... what is better to do ? How do it ? How is better managing the site ?
Change things in local and than put online ?! Is there a better way to sincronize them ?

Hoping I'm been more clear ...

Just a little note from a newbie:
I have followed Guilliam's fantastic post on backing up your database via phpMyadmin and have finally successfully backed up and moved my site to another server.

I just wanted to post a note of an issue I had and how it was resolved.
I was initially using Safari to export my database via phpMyadmin. When I attempted to download the DB as a compressed file (gzip), all I got was an uncompressed file. When I attempted to restore the DB, I got errors in phpMyadmin.

I then switched over to Firefox and was able to export the DB as a compressed gzip. When I restored from the gzip. Everything went very smoothly. PhpMyadmin must like the gzip version better.

I don't no if anyone else has had the same issue but from now on, I will only export the DB using Firefox as my browser so I can get the gzip file.

BTW, thanks much to Guilliam for his very clear and well instructed posts. I find his explanations to be the easiest to understand and implement from a newbie perspective. Thanks G! 

@eideas, thanks for the input regarding SAFARI, have made the walkthru for general audience(using i.e. of f.f.).. however thank you for the additional info that you get errors in safari. will take that noted and edit the first post to warn NOT to use safari for this.

@doctorlife, im really sorry,. i think its the language barrier that we have that i STILL cannot understand what youre trying to say. sorry.


- g

These instructions have been great however I have found one big bug (from my point of view).  I created my articles using JoomlaFCK because of the image handling capabilities.  My pages on my local server look great.

However !!!! The absolute path is stored in the table jos_content so when I move my DB the paths to all my images do not work.

Why does Joomla not use relative paths like "images/stories" instead of "http://localhost/mysite/joomla/images/stories"

Any ideas and help on this to avoid any future problems would be appreciated

hello,

i followed this process of moving an offline db to an online location and got this error after clicking the SQL button to import the gzipped file.  any ideas please? i used jsas to develop offline site. 

EDIT 1:  The error was a 1064 error. 

EDIT 2:

Perhaps this has something to do with it - the phpmyadmin versions are different on offline and online server's?

JSAS 1.0.3 (the offline server) is:
phpMyAdmin 2.6.0-rc3
MySQL 4.1.14-nt running

Online it is:
phpMyAdmin 2.6.4-pl2
MySQL 4.0.25-standard running

EDIT 3 - Case closed, solution posted here

Where do I select MySQL compability??

Rgds
Erik

There is nothing wrong with Safari !
But you need to turn of the 'Open safe files after downloading'. If checked Safari will automatically decompress the .zip files and delete the original.

Fonny

check this quote from one of the thread reply i made: