Re: file privilege

Correct. Carlos On Tue, Jan 31, 2012 at 12:03 AM, kalin m wrote: > > > thanks carlos. so if i go with: > > "grant file on user " > > that wont infringe on the all other privileges the user already has, > correct? > > > thanks.. > > > > On 1/31/12 12:47 AM, Carlos Proal wrote: > > Hi, > > >

Re: file privilege

thanks carlos. so if i go with: "grant file on user " that wont infringe on the all other privileges the user already has, correct? thanks.. On 1/31/12 12:47 AM, Carlos Proal wrote: > Hi, > > You have look at the "user" table which has global privileges, "db" is > specific to each dat

Re: file privilege

Hi, You have look at the "user" table which has global privileges, "db" is specific to each database. Carlos On Mon, Jan 30, 2012 at 10:56 PM, kalin m wrote: > > > hi... > > so i have this user in the user table in the mysql db that has all the > privileges but "grant". now i need for that us

file privilege

hi... so i have this user in the user table in the mysql db that has all the privileges but "grant". now i need for that user to have the "file" privilege so it can do "into outfile". thing is i don't see that privilege anywhere in the db table. i know that i have to do the "grant file on user@l

Re: Converting Microsoft SQL database to MySQL

2012/01/30 15:06 +0800, James I am involved in a project to migrate our entire database from Microsoft SQL to MySQL. I would appreciate the help if anyone could share what tools will you recommend of converting SQL database to MySQL. If it is SQL server, maybe dumping in charact

Re: Converting Microsoft SQL database to MySQL

Thanks Carl. I found a tool called Full Convert that did conversion (small database only) from MSSQL to MySQL. I tried to test their Trial version and it converts completely with similar structure, fields, etc.. Because it's trial version, some more than 5

Re: Converting Microsoft SQL database to MySQL

I do this quite frequently. In our case, we are converting competitors data so the process is to use Navicat (premium) to bring the data from MSSQL to MySQL (in the same fields, etc.) and then use a program to convert it into our format so it will run on our system. The only thing I have had t