severin, antipop, anyone else good with databases

wHATcOLOR · 08-03-2009, 10:06 PM

i have a few questions, would you mind trying to help me a little bit?

thanks!

Nimrod's Son · 08-04-2009, 01:04 AM

maybe it would help if you posted those questions

severin · 08-04-2009, 01:21 AM

Quote:

Originally Posted by Nimrod's Son

maybe it would help if you posted those questions

this

wHATcOLOR · 08-04-2009, 02:14 AM

a little background, most of my experience with databases has been as an end-user. first stuff like business objects and microstrategies to query and run reports. then i got into editing and creating new stored procedures to create transformations and build new tables i needed and all that with sql server, writing some sql and using it in query analyser, designing and building olap cubes with cognos, etc. but this was all with databases that were built by someone else, largely using and modifying existing processes in place to create what i needed.

and i haven't really done any of that in about two years.

so for this new thing, we've got a mysql database housing data from our production server.

i want to query against this data, but i don't want to touch the production environment. i've got crystal reports 2008 on hand for querying.

our guy suggested the following. he's going to write a script that will dump the database so that i can mount it locally in mysql on my machine. i only vaguely know what that means, and i haven't used mysql

i don;t have mysql loaded, so i'm basically asking for install/config advice. i'm assuming i download mysql community server? windows x64 since i have vista 64 bit?

do i want the complete version, or the essentials? log on as administrator and open a port? anything i should be aware of there?

was told to set up sftp -- any client universally regarded as the one to use?

i don't really know anything about scripts -- what should i expect there? how do i 'run' a script? is it likely the script will build the database, or is it likely he'll assume i have something already set up?

i will probably have some more questions once this is up and i'm trying to use the odbc connector to hook crystal up to it, but for now, i'm just trying to understand what's being set up..

thanks.

wHATcOLOR · 08-04-2009, 02:18 AM

p.s. this is for a short term solution, longer term as things stabilize, we'll move in the direction of data warehousing, etc. for now, i'm just trying to extract some intelligence from what we've got going on right now, and do it pretty quickly w/o much concern over sustainability of the process, etc.

severin · 08-04-2009, 02:32 AM

version: community server 64 bit windows msi installer:

MySQL :: Select a Mirror

i'd suggest you get the gui-toolpack as well, since they really are a helpful addition and amke it easier to administrate and run querys (there is no dedicated x64 version, but the x86 should run with no problems):
MySQL :: Select a Mirror

with the gui you can connect to localhost on the specified port, which should be entered automatically and should work unless you change it during installing

for the sftp i can't help you there, but i'm pretty sure download.com has some good freeware stuff there.

if he creates a mysql-dump script for you, you will need to have a database locally already, as it will normally not be created by the script. i recommend emptying out the database before you run the script (or even better, drop the DB, create a new one, saves you a lot of hassle), especially if you make use of Foreign Key Constraints (which you should

), since i have sometimes encountered problems with the sequence tables where dropped/created in conjunction with FK's in mysql-dump-scripts.

run the script in the query-tool against an empty database and you should be fine...

hope that helped, if you need any more, just drop me a pm or an email

wHATcOLOR · 08-04-2009, 02:38 AM

ok, thanks. how do i create a database that i can run the script against?

severin · 08-04-2009, 02:43 AM

Quote:

Originally Posted by wHATcOLOR

ok, thanks. how do i create a database that i can run the script against?

either use the administration tool, or use the following script:

Code:

DROP DATABASE [dbname];
CREATE DATABASE [dbname];

not, this will give you an error on the first line, if the db doesn't yet exist, but shoud still create it

btw: i've just looked it up, there IS a possibility to include the drop/create in the dump-file of the db itself, so you could save yourself the trouble if the guy who provides it makes sure it is included

wHATcOLOR · 08-04-2009, 02:44 AM

del -- user error

wHATcOLOR · 08-04-2009, 02:47 AM

thanks, i'll give it a try..

any idea about the vista 'log on as administrator and open a port' thing -- will i need to do that for a script to run?

severin · 08-04-2009, 02:51 AM

Quote:

Originally Posted by wHATcOLOR

thanks, i'll give it a try..

any idea about the vista 'log on as administrator and open a port' thing -- will i need to do that for a script to run?

honestly, my vista experience is kinda low, but i'd suggest that you should run all the installers and the gui as admin to avoid trouble (although the gui might well run without). opening the port should not be a problem unless you want to access the database from outside the machine you run the mysql on, afaik localhost is excluded of the vista firewall rules

wHATcOLOR · 08-04-2009, 02:59 AM

thank you for your guidance

severin · 08-04-2009, 03:30 AM

Quote:

Originally Posted by wHATcOLOR

thank you for your guidance

you're welcome, i hope it works out

redbull · 08-04-2009, 03:47 AM

i'd recommend filezilla if you're looking for an ftp client

Nimrod's Son · 08-04-2009, 04:07 AM

Severin covered everything already, but for an SFTP client for Vista, I'd go with WinSCP.

Mo · 08-04-2009, 04:23 AM

FileZilla and WinSCP are both open-source and have about the same features, so it's more a question of taste. I prefer FZ.

ChristHimself! · 08-04-2009, 04:42 AM

filezilla keeps randomly disconnected me from the ftp servers im connected to lately, and its not just the one server, its any

i should probably uninstall it and grab a newer version

i blame severin

severin · 08-04-2009, 04:45 AM

Quote:

Originally Posted by ChristHimself!

i blame severin

ATS · 08-04-2009, 10:40 AM

since youre running 64 bit vista youre going to have to refresh your system 32 files before you will get it wo work

wHATcOLOR · 08-05-2009, 12:04 AM

hey nimrod or severin i was trying to configure mysql after installing the download from the link you provided. when i go to execute the configuration, it dies at "start service". it says "Cannot create Windows service for MySQL. Error: 0"

any suggestions?

wHATcOLOR · 08-05-2009, 12:24 AM

i think it has to do witht he option "start this as a windows service" .. i don't even really know what that means

i think it also has to do with being logged into an account having administrative rights on my vista machine.. which i also don't really know the particulars of

Nimrod's Son · 08-05-2009, 12:49 AM

Did you re-install or upgrade MySQL without first stopping and removing the existing MySQL service using the MySQL Configuration Wizard? This happens because when the Configuration Wizard tries to install the service it finds an existing service with the same name.

One solution to this problem is to choose a service name other than mysql when using the configuration wizard. This will allow the new service to be installed correctly, but leaves the outdated service in place. While this is harmless it is best to remove old services that are no longer in use.

To permanently remove the old mysql service, execute the following command as a user with administrative privileges, on the command-line:

C:\>sc delete mysql
[SC] DeleteService SUCCESS

Take a look at MySQL :: MySQL 5.1 Reference Manual :: 2.3.13 Troubleshooting a MySQL Installation Under Windows

also this may happens when you have installed MyQL in the C:/Program Files/....
the space between Program & files also prevent from creating/starting service..
So install MySQL server in C:/ itself say C:/MYSQL

wHATcOLOR · 08-12-2009, 12:06 AM

thanks -- i coudln't get the sc delete mysql thing to work w/o being administrator, which i still don't fucking thoroughly understand..

anyhow, got it installed, named it something else, not running as a windows service, did not install it in program files, did it right on the c drive as you said..

received the script to set up the DB today --

was hoping severin (or nimrod if you're familiar with it) could give me a run through of the fundamentals of what i've installed. specifically, the gui tools, etc. what do i need to run to get everything running. do i just open the query browser, and that will start up mysql community server too?

sorry if im being unclear, my brain isn't working too well, just had my first meal of solid food since friday..

08-03-2009, 10:06 PM	#1
wHATcOLOR THIS IS AWESOME!!!!!!!!!! Location: whip that's for stealing !! whip And that's for getting blood on my whip !!! \|\| MY NAME IS KIIIIIIIIIIIIIIIIIIIIIIIIIIIID ROCK!! Posts: 44,827	severin, antipop, anyone else good with databases i have a few questions, would you mind trying to help me a little bit? thanks!

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
stupid religious argument	I'm Hardcore	General Chat Message Board	332	02-29-2012 11:34 AM
good old youtube, always good for a laugh	skipgo	Pumpkins Archive	15	03-27-2008 12:41 AM
who missed sh sh shayne?	sh sh shayne	General Chat Archive	32	02-12-2008 11:19 PM
Guys, I need your help. No joking around this time.	sickbadthing	General Chat Archive	34	02-07-2008 01:13 PM
BLOG	Frankenstein	General Chat Archive	13	01-30-2008 09:30 AM

08-04-2009, 01:04 AM	#2
Nimrod's Son Master of Karate and Friendship Location: in your butt Posts: 72,971	maybe it would help if you posted those questions

08-04-2009, 02:14 AM	#4
wHATcOLOR THIS IS AWESOME!!!!!!!!!! Location: whip that's for stealing !! whip And that's for getting blood on my whip !!! \|\| MY NAME IS KIIIIIIIIIIIIIIIIIIIIIIIIIIIID ROCK!! Posts: 44,827	a little background, most of my experience with databases has been as an end-user. first stuff like business objects and microstrategies to query and run reports. then i got into editing and creating new stored procedures to create transformations and build new tables i needed and all that with sql server, writing some sql and using it in query analyser, designing and building olap cubes with cognos, etc. but this was all with databases that were built by someone else, largely using and modifying existing processes in place to create what i needed. and i haven't really done any of that in about two years. so for this new thing, we've got a mysql database housing data from our production server. i want to query against this data, but i don't want to touch the production environment. i've got crystal reports 2008 on hand for querying. our guy suggested the following. he's going to write a script that will dump the database so that i can mount it locally in mysql on my machine. i only vaguely know what that means, and i haven't used mysql i don;t have mysql loaded, so i'm basically asking for install/config advice. i'm assuming i download mysql community server? windows x64 since i have vista 64 bit? do i want the complete version, or the essentials? log on as administrator and open a port? anything i should be aware of there? was told to set up sftp -- any client universally regarded as the one to use? i don't really know anything about scripts -- what should i expect there? how do i 'run' a script? is it likely the script will build the database, or is it likely he'll assume i have something already set up? i will probably have some more questions once this is up and i'm trying to use the odbc connector to hook crystal up to it, but for now, i'm just trying to understand what's being set up.. thanks.

08-04-2009, 02:18 AM	#5
wHATcOLOR THIS IS AWESOME!!!!!!!!!! Location: whip that's for stealing !! whip And that's for getting blood on my whip !!! \|\| MY NAME IS KIIIIIIIIIIIIIIIIIIIIIIIIIIIID ROCK!! Posts: 44,827	p.s. this is for a short term solution, longer term as things stabilize, we'll move in the direction of data warehousing, etc. for now, i'm just trying to extract some intelligence from what we've got going on right now, and do it pretty quickly w/o much concern over sustainability of the process, etc.

08-04-2009, 02:32 AM	#6
severin no more than sympathy Location: lying on the floor Posts: 14,833	version: community server 64 bit windows msi installer: MySQL :: Select a Mirror i'd suggest you get the gui-toolpack as well, since they really are a helpful addition and amke it easier to administrate and run querys (there is no dedicated x64 version, but the x86 should run with no problems): MySQL :: Select a Mirror with the gui you can connect to localhost on the specified port, which should be entered automatically and should work unless you change it during installing for the sftp i can't help you there, but i'm pretty sure download.com has some good freeware stuff there. if he creates a mysql-dump script for you, you will need to have a database locally already, as it will normally not be created by the script. i recommend emptying out the database before you run the script (or even better, drop the DB, create a new one, saves you a lot of hassle), especially if you make use of Foreign Key Constraints (which you should ), since i have sometimes encountered problems with the sequence tables where dropped/created in conjunction with FK's in mysql-dump-scripts. run the script in the query-tool against an empty database and you should be fine... hope that helped, if you need any more, just drop me a pm or an email

08-04-2009, 02:38 AM	#7
wHATcOLOR THIS IS AWESOME!!!!!!!!!! Location: whip that's for stealing !! whip And that's for getting blood on my whip !!! \|\| MY NAME IS KIIIIIIIIIIIIIIIIIIIIIIIIIIIID ROCK!! Posts: 44,827	ok, thanks. how do i create a database that i can run the script against?

08-04-2009, 02:44 AM	#9
wHATcOLOR THIS IS AWESOME!!!!!!!!!! Location: whip that's for stealing !! whip And that's for getting blood on my whip !!! \|\| MY NAME IS KIIIIIIIIIIIIIIIIIIIIIIIIIIIID ROCK!! Posts: 44,827	del -- user error

08-04-2009, 02:47 AM	#10
wHATcOLOR THIS IS AWESOME!!!!!!!!!! Location: whip that's for stealing !! whip And that's for getting blood on my whip !!! \|\| MY NAME IS KIIIIIIIIIIIIIIIIIIIIIIIIIIIID ROCK!! Posts: 44,827	thanks, i'll give it a try.. any idea about the vista 'log on as administrator and open a port' thing -- will i need to do that for a script to run?

08-04-2009, 02:59 AM	#12
wHATcOLOR THIS IS AWESOME!!!!!!!!!! Location: whip that's for stealing !! whip And that's for getting blood on my whip !!! \|\| MY NAME IS KIIIIIIIIIIIIIIIIIIIIIIIIIIIID ROCK!! Posts: 44,827	thank you for your guidance

08-04-2009, 03:47 AM	#14
redbull Immortal Location: i am the best rapper alive Posts: 20,052	i'd recommend filezilla if you're looking for an ftp client

08-04-2009, 04:07 AM	#15
Nimrod's Son Master of Karate and Friendship Location: in your butt Posts: 72,971	Severin covered everything already, but for an SFTP client for Vista, I'd go with WinSCP.

08-04-2009, 04:23 AM	#16
Mo Shalom y'all Location: Wien Posts: 20,262	FileZilla and WinSCP are both open-source and have about the same features, so it's more a question of taste. I prefer FZ.

08-04-2009, 04:42 AM	#17
ChristHimself! mental problems angel Location: i want u 2 caress me like a tropical priest Posts: 20,612	filezilla keeps randomly disconnected me from the ftp servers im connected to lately, and its not just the one server, its any i should probably uninstall it and grab a newer version i blame severin

08-04-2009, 10:40 AM	#19
ATS Registered User Posts: 2,332	since youre running 64 bit vista youre going to have to refresh your system 32 files before you will get it wo work

08-05-2009, 12:04 AM	#20
wHATcOLOR THIS IS AWESOME!!!!!!!!!! Location: whip that's for stealing !! whip And that's for getting blood on my whip !!! \|\| MY NAME IS KIIIIIIIIIIIIIIIIIIIIIIIIIIIID ROCK!! Posts: 44,827	hey nimrod or severin i was trying to configure mysql after installing the download from the link you provided. when i go to execute the configuration, it dies at "start service". it says "Cannot create Windows service for MySQL. Error: 0" any suggestions?

08-05-2009, 12:24 AM	#21
wHATcOLOR THIS IS AWESOME!!!!!!!!!! Location: whip that's for stealing !! whip And that's for getting blood on my whip !!! \|\| MY NAME IS KIIIIIIIIIIIIIIIIIIIIIIIIIIIID ROCK!! Posts: 44,827	i think it has to do witht he option "start this as a windows service" .. i don't even really know what that means i think it also has to do with being logged into an account having administrative rights on my vista machine.. which i also don't really know the particulars of

08-05-2009, 12:49 AM	#22
Nimrod's Son Master of Karate and Friendship Location: in your butt Posts: 72,971	Did you re-install or upgrade MySQL without first stopping and removing the existing MySQL service using the MySQL Configuration Wizard? This happens because when the Configuration Wizard tries to install the service it finds an existing service with the same name. One solution to this problem is to choose a service name other than mysql when using the configuration wizard. This will allow the new service to be installed correctly, but leaves the outdated service in place. While this is harmless it is best to remove old services that are no longer in use. To permanently remove the old mysql service, execute the following command as a user with administrative privileges, on the command-line: C:\>sc delete mysql [SC] DeleteService SUCCESS Take a look at MySQL :: MySQL 5.1 Reference Manual :: 2.3.13 Troubleshooting a MySQL Installation Under Windows also this may happens when you have installed MyQL in the C:/Program Files/.... the space between Program & files also prevent from creating/starting service.. So install MySQL server in C:/ itself say C:/MYSQL

08-12-2009, 12:06 AM	#23
wHATcOLOR THIS IS AWESOME!!!!!!!!!! Location: whip that's for stealing !! whip And that's for getting blood on my whip !!! \|\| MY NAME IS KIIIIIIIIIIIIIIIIIIIIIIIIIIIID ROCK!! Posts: 44,827	thanks -- i coudln't get the sc delete mysql thing to work w/o being administrator, which i still don't fucking thoroughly understand.. anyhow, got it installed, named it something else, not running as a windows service, did not install it in program files, did it right on the c drive as you said.. received the script to set up the DB today -- was hoping severin (or nimrod if you're familiar with it) could give me a run through of the fundamentals of what i've installed. specifically, the gui tools, etc. what do i need to run to get everything running. do i just open the query browser, and that will start up mysql community server too? sorry if im being unclear, my brain isn't working too well, just had my first meal of solid food since friday..