RE: Trying to open a big sql script

If you are under windows, you should try Textpad (http://www.textpad.com/) In any case, a hex editor will do what you're looking for. Hope to help, Andy -Original Message- From: molemenacer [mailto:[EMAIL PROTECTED] Sent: Thursday, April 19, 2007 6:44 AM To: mysql@lists.mysql.com Sub

character_set_xxx

Hi, How can I change character_set_xxx variables in MySQL 4.1.x in Linux? Regards, Behrang -- Behrang Saeedzadeh http://www.jroller.com/page/behrangsa http://my.opera.com/behrangsa -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.my

Re: Help please: SELECT in binlog?

Fionn Behrens wrote: On Do, 2007-04-19 at 13:57 -0400, Jay Pipes wrote: You can have both, AFAIK. The general query log keeps all queries, including SELECTs. Binlog only has data-modifying queries. Thanks very much for your answer. Maybe the fact that binlogs apparently are quite different

Re: Help please: SELECT in binlog?

On Do, 2007-04-19 at 13:57 -0400, Jay Pipes wrote: > You can have both, AFAIK. The general query log keeps all queries, > including SELECTs. Binlog only has data-modifying queries. Thanks very much for your answer. Maybe the fact that binlogs apparently are quite different from normal text lo

Re: Help please: SELECT in binlog?

Fionn Behrens wrote: We recently switched to mysql5 and while we were at it we also changed our logs from text to bin as suggested by the migration script we had (probably created by debian people). Now I unfortunately had to reconstruct what had happened during a faulty run of our application a

Help please: SELECT in binlog?

We recently switched to mysql5 and while we were at it we also changed our logs from text to bin as suggested by the migration script we had (probably created by debian people). Now I unfortunately had to reconstruct what had happened during a faulty run of our application and I could not get any

Re: Trying to open a big sql script

Something like this should do the trick: ~#replace "mthosp" "newname" < org-file.sql > new-file.sql -- Later Mogens Melander +45 40 85 71 38 +66 870 133 224 On Thu, April 19, 2007 16:53, molemenacer wrote: > > I am trying to change all the names of the database from mthosp to another > name,

Re: Trying to open a big sql script

On Thursday 19 April 2007 15:53:54 molemenacer wrote: > I am trying to change all the names of the database from mthosp to another > name, is this possible? Assuming you mean tables, not database (as mysqldump doesn't store the database name in the dump file [or at least never has for me]): sed

Re: Trying to open a big sql script

I am trying to change all the names of the database from mthosp to another name, is this possible? Dan Buettner-2 wrote: > > That's a much larger file than most any text editor would work with, in my > experience. I'd give BBEdit on the Mac a try if nothing else, but my > expectations would no

Re: Trying to open a big sql script

It might be a little late for this advice but mysqldump has some useful options for this kind of thing. When I use it to create full snapshots, I use a script which generates a separate schema file per table/view and keep the data in one or more per table for data. naming conventions keep keep the

Re: Problem on millions of records in one table?

He, Ming Xin PSE NKG wrote: Hi, Pipes Is it reliable to use MySQL 5.1 in a commercial product now since it is still a beta version? Hmmm. Probably depends on what you are doing with it... But, in general, it's fairly sta ble at this point but, like all beta software, cannot be considered a

Mysql and disk space left

Hi all, I wonder what is the impact of the disk space left for a mysql DB (MyIsam, Linux 2.6, Ext3, RAID5). I mean, I there a kind of limit to not cross to limit the performances impact ? Cheers, Manuel -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscrib

Re: Trying to open a big sql script

On Thu, April 19, 2007 12:48, Duncan Hill wrote: > On Thursday 19 April 2007 11:43:34 molemenacer wrote: >> Hi all, >> >> I have backed up a database using mysqldump and have a .sql script that >> is >> over 2GB in size. I am trying to open this file to view it and make >> some >> changes. I hav

Re: Trying to open a big sql script

That's a much larger file than most any text editor would work with, in my experience. I'd give BBEdit on the Mac a try if nothing else, but my expectations would not be too high. For examining and altering a file that large I'd try grep, awk, sed, perl, etc. Barring that, one thing you might d

Re: Trying to open a big sql script

On Thursday 19 April 2007 11:43:34 molemenacer wrote: > Hi all, > > I have backed up a database using mysqldump and have a .sql script that is > over 2GB in size. I am trying to open this file to view it and make some > changes. I have not been able to find a program that can open this file. > >

Trying to open a big sql script

Hi all, I have backed up a database using mysqldump and have a .sql script that is over 2GB in size. I am trying to open this file to view it and make some changes. I have not been able to find a program that can open this file. Does anyone have any suggestions as to a program that can do this