Joomla! Discussion Forums

I'm trying to take my site from MSAS and upload it to my server.

I took all the contents from the mambo folder, uploaded them. I know i need to modify my config file, but im not sure all of what to change, and what to change it to.

The big question is how to transfer the database over. I used phpMyadmin and exported a cvs gzipped file of the database. I then get a huge error in phpMyadmin on my server when i try to import it. Why would this be?

error:


There is a chance that you may have found a bug in the SQL parser. Please examine your query closely, and check that the quotes are correct and not mis-matched. Other possible failure causes may be that you are uploading a file with binary outside of a quoted text area. You can also try your query on the MySQL command line interface. The MySQL server error output below, if there is any, may also help you in diagnosing the problem. If you still have problems or if the parser fails where the command line interface succeeds, please reduce your SQL query input to the single query that causes problems, and submit a bug report with the data chunk in the CUT section below:
----BEGIN CUT----
eNpzDQryD7JScDZUcDZS8HH1s1IwUDBUMDfgCg4BCstzcTmHBV spqHimWCkUF+YUJBYVpxbp5WQm
6RVkFOiUKRjpGVkoGBkYmOobGOsbGikYGluZmlkZmSjkpOZaKr hWFCiocPlWBgf6WCmY6BnoGZnq
Fpck5qUkFqVwhQYHKfgH6yg4urv6hegohLkC7QvPzFPw9Y/y9PFxVDDVM+AK8HW0AtphpmekW5Bj
yBXgEQBSp+MfDDLOWM/QUMEnM6+0gsvH0c/dSiE1TzezOF/XwsLUUteQC2ypfDcHAxgwv639WXx7
27YP72dd/N/weub1LZ8jubdWZs75LqPuV6vu9+fRkp3ffdPVckqsRVg912hOe prkOvf38frnMjos
ml6LdAACeVt0
----END CUT----
----BEGIN RAW----

ERROR: C1 C2 LEN: 0 1 70
STR: 

CVS: $Id: sqlparser.lib.php,v 2.28 2005/03/12 13:56:24 lem9 Exp $
MySQL: 4.0.25-standard
USR OS, AGENT, VER: Win MOZILLA 5.0
PMA: 2.6.2-pl1
PHP VER,OS: 4.3.11 Linux
LANG: en-iso-8859-1

This may be due to differences in MySql versions in MSAS and on your server.  May be worth investigating...

Assuming there are differences, what can be done.

Why dont you export it as sql file type? compressed with gzip

Then, if you still have problems, check for previous MySQL compatibility, as it has an option if it is MySQL +4.x

If that doesnt work, come back

Greetings,
Federico Almada

Alright,will do, I'll get back to you when i try it laterthis evening.

Hmm okay, i tried it not compressed, and it worked kinda.. however it didn't work because the database was wrong. But my database must be mplionhe_mplionhearts for this.

So what do i need to do in order to get it to work?

-- phpMyAdmin SQL Dump
-- version 2.6.0-rc3
-- http://www.phpmyadmin.net
--
-- Host: localhost
-- Generation Time: Aug 22, 2005 at 06:24 PM
-- Server version: 4.0.23
-- PHP Version: 4.3.4
--
-- Database: `msas452`
--
CREATE DATABASE `msas452`

Nevermind I got it, but now i have a question, what do i do with this file:

$mosConfig_offline = '0';
$mosConfig_host = 'localhost';
$mosConfig_user = 'root';
$mosConfig_password = '';
$mosConfig_db = 'mplionhearts';
$mosConfig_dbprefix = 'mos_';
$mosConfig_lang = 'english';
$mosConfig_absolute_path = 'w:/www/Mambo452';
$mosConfig_live_site = 'http://localhost:85/mambo452';
$mosConfig_sitename = 'Mountain Pointe Bands http://www.mplionhearts.com';
$mosConfig_shownoauth = '0';
$mosConfig_useractivation = '1';
$mosConfig_uniquemail = '1';
$mosConfig_offline_message = 'This site is down for maintenance.
Please check back again soon.';
$mosConfig_error_message = 'This site is temporarily unavailable.
Please notify the System Administrator';
$mosConfig_debug = '0';
$mosConfig_lifetime = '900';
$mosConfig_MetaDesc = 'Mambo - the dynamic portal engine and content management system';
$mosConfig_MetaKeys = 'mambo, Mambo';
$mosConfig_MetaAuthor = '1';
$mosConfig_MetaTitle = '1';
$mosConfig_locale = 'en_GB';
$mosConfig_offset = '0';
$mosConfig_hideAuthor = '0';
$mosConfig_hideCreateDate = '0';
$mosConfig_hideModifyDate = '0';
$mosConfig_hidePdf = '0';
$mosConfig_hidePrint = '0';
$mosConfig_hideEmail = '0';
$mosConfig_enable_log_items = '0';
$mosConfig_enable_log_searches = '0';
$mosConfig_enable_stats = '0';
$mosConfig_sef = '0';
$mosConfig_vote = '0';
$mosConfig_gzip = '0';
$mosConfig_multipage_toc = '1';
$mosConfig_allowUserRegistration = '0';
$mosConfig_link_titles = '0';
$mosConfig_error_reporting = '-1';
$mosConfig_list_limit = '50';
$mosConfig_caching = '0';
$mosConfig_cachepath = 'w:/www/Mambo452/cache';
$mosConfig_cachetime = '900';
$mosConfig_mailer = 'mail';
$mosConfig_mailfrom = 'notreal@nowhere.no';
$mosConfig_fromname = 'MSAS 4.5.2 by mambosolutions.com';
$mosConfig_sendmail = '/usr/sbin/sendmail';
$mosConfig_smtpauth = '0';
$mosConfig_smtpuser = '';
$mosConfig_smtppass = '';
$mosConfig_smtphost = 'localhost';
$mosConfig_back_button = '1';
$mosConfig_item_navigation = '1';
$mosConfig_secret = 'zUmLjscBz8xfvz97';
$mosConfig_pagetitles = '1';
$mosConfig_readmore = '1';
$mosConfig_hits = '1';
$mosConfig_icons = '1';
$mosConfig_favicon = 'favicon.ico';
$mosConfig_fileperms = '';
$mosConfig_dirperms = '';
$mosConfig_mbf_content = '0';
$mosConfig_helpurl = 'http://help.mamboserver.com';
setlocale (LC_TIME, $mosConfig_locale);
?>

All my helpful people are sleeping oh well I only have 1 class tomorrow so I suppose I can do it tomorrow.

You need to change these to point to your server and its path, for example:

$mosConfig_absolute_path = '/yourhostpath/Mambo452';
$mosConfig_live_site = 'http://www.yourhostname.com/mambo452';

And lastly, use PhpAdmin to create a new user and password for your database and change these accordingly:

$mosConfig_user = 'new id';
$mosConfig_password = 'new password';

new user and password for database? This is something i haven't done before actually. I mean i have a username and password for all my databases already. Just my server user and pass.

Also, is there a way i can find my host path? I mean I know what you're talking about, I just don't remember it.

This should help:
Posted by Molok in the FAQs forum.
http://forum.opensourcematters.org/inde ... 035.0.html

Dean Marshall.

Thanks for the help with the absolute path good stuff.