Technology Tools for Ministry

Community

Web-Empowered Church User Community
All Categories > Getting Started > Installing (WEC Starter Package) > importing database dump to the "WEC-TYPO3 Server for PC"
Total Posts: 3 - Pages (1): [1]
user picture Author: Christoph Haas
Posted: Jul 19 2008 - 04:31 AM
Subject: importing database dump to the "WEC-TYPO3 Server for PC"
Hello!

back from holidays, I'd like to use the "WEC-TYPO3 Server for PC" as testing ground (templates, updates etc.) on my local Windows-machine. So I backed up my database from my running WEC-installation in the Internet, and everything else I needed.

Now I have real trouble importing my database dump. The "WEC-TYPO3 Server for PC" is running, but when trying to connect in a DOS-box to MySQL , I get the following error:

Microsoft Windows XP [Version 5.1.2600]
(C) Copyright 1985-2001 Microsoft Corp.

D:\Christoph\wec-421-1_fullserver\server\mysql\bin>mysql -u root
ERROR 2003 (HY000): Can't connect to MySQL server on 'localhost' (10061)


P.S.: I get the same error when trying to use MySQLdumper (http://www.mysqldumper.de/) - a very good tool for backing up and restoring MySQL-databases - instead.

I figured out that the MySQL-user "root" has no password set in the "WEC-TYPO3 Server for PC", but now I'm stuck.

I tried also with the included phpMyAdmin: "SQL -> Import files", but here I get also an error:

SQL query:

SELECT label, id
FROM `phpmyadmin`.`PMA_bookmark`
WHERE dbase = 'wec_production'
AND (
user = 'root'
OR user = ''
)
ORDER BY label

MySQL said: Documentation
#1146 - Table 'phpmyadmin.pma_bookmark' doesn't exist

... and the import seems broken

How can I import my database dump into the "WEC-TYPO3 Server for PC"

Any help is appreciated!
TIA
Christoph.
Author: Manfred Hungerland
Posted: Jul 21 2008 - 03:43 AM
Subject: re: importing database dump to the "WEC-TYPO3 Server for PC"
Hi Christoph

did You start the WEC-TYPO3 Server for PC?
If Yes.

Erase the hole installation and unpack it again. It should Work.

Shalom
Manfred
user picture Author: Christoph Haas
Posted: Jul 21 2008 - 04:00 AM
Subject: re: importing database dump to the "WEC-TYPO3 Server for PC"
Hello,

now I solved my problem on my own. Just for reference the solution:

1. Start the MySQL-daemon with the path to the MySQL-datadir in a DOS-box - the WEC-Server does not need to be started, but it does not hurt anyway, in my case:
D:\Christoph\wec-421-1_fullserver\server\mysql\bin>mysqld --datadir=D:\Christoph
wec-421-1_fullserver\dbdir

2. In case your database-backup does not contain a statement to create the database, do it by hand:
D:\Christoph\wec-421-1_fullserver\server\mysql\bin>mysql -u root
Welcome to the MySQL monitor. Commands end with ; or g.
Your MySQL connection id is 229 to server version: 4.1.20-community

Type 'help;' or 'h' for help. Type 'c' to clear the buffer.

mysql> create database wec_production;
Query OK, 1 row affected (0.03 sec)

mysql> show databases;
+----------------+
| Database |
+----------------+
| mysql |
| wec_production |
| wectypo3 |
+----------------+
4 rows in set (0.00 sec)

mysql>exit
D:\Christoph\wec-421-1_fullserver\server\mysql\bin>

3. Import the database in another DOS-box, or via any tool you'd like (MySQLdumper, phpMyAdmin etc.) e.g.:
D:\Christoph\wec-421-1_fullserver\server\mysql\bin>mysql -u root --default-character-set=utf8 wec_production < D:Christophwec-421-1_fullserverdbdirwec_production.sql

4. Change the database in the Typo3-install-tool to your imported backup of your production database, in my case to "wec_production"


you're done
Cheers from Fellbach / BW / Germany
Christoph.
Total Posts: 3 - Pages (1): [1]
Click here for a complete list of threads
You must login to post a message to this conference.