similar to: Uploading BLOB into MySQL

Dear R-users, I have conducted an experiment with a 2*2*2 factorial within-subjects design. All factors are binary and the dependent measure is a frequency of successes between 0 and 4. Treating this as a normally distributed variable, I would perform a repeated-measures ANOVA as follows: > aov(y ~ A*B*C + Error(subj/(A+B+C))) but since the distribution of the dependent measure is clearly

we have multiple servers approx 10 and each has about 100 GB of data in the /var/lib/mysql dir , excluding tar , mysqldump and replication how do we take backup for these databases on to a remote machine and store them datewise , ( the remote machine is a 2TB HDD ) currently tar is not feasible as the data is too huge and the same goes with mysqldump suggestion will be of great help --

Hi all. I usally make backups of databases mysql. I make buckups of all datbase for example: mysqldump -u user -ppassword name_db > backups.sql also I make backups just its schema for example mysqldump -u user -ppassword name_db --no-data > backups.sql but now I need a backups incrementals, because the size of DB is very big (500 mb) How to make this? regards -- *Atte.

I need export an registers of a data base from command line. It is possible with mysqldump? for example: mysqldump -u user -ppass db "select *from users where id=20" ??? thank

Hello, We have MySQL running as a master which is replicating to a single slave server. We are, however, considering what is required when a 'disaster' of some sort happens to either server. By disaster, this could be some event which requires the entire server to be rebuilt, and which would usually include restoring from nightly backups directories such as '/var/lib/mysql' and

Not really a rails question but someone on here may be able to help.. I have been backing up a MySQL database for a Rails app for several years with the command: mysqldump myDatabaseName -u root > myBackupFile.sql The backups have appeared to work fine... I then wanted to restore one of the backups to a different named database so I did: mysql myNewDatabaseName -u root < myBackupFile.sql

Is it possible? It is mentioned in AWDWR but I cannot find that option in the MySQL documentation. I can dump the whole db or just the structure, but I''d like to be able to dump just the contents. bruce

Hi , Help is needed to restore mysql data This is the the setup. 2 Servers running on CentOS. one server has both apache an mysql. the other server only has mysql database. This server has about 12000 records in the database. Last week, It had about 6000 records. then, Someone has backed up these 6000 records to the web server. Now , We need to backup all 12000 records to the webserver.

I just installed CentOS 3.5. Included in the install was mysql. When trying to start it using: service mysqld start. The system responds with mysqld not recpognized as a service. When trying to use /usr/bin/mysql I receive this error: ERROR 2002: Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2). A search of the system does not reveal

Hi All, Please help me ,I need to look into this issue asap, I need to change the redmine functionality of uploading files to disk to upload them to database. I tried suggestion on http://dizzy.co.uk/ruby_on_rails/contents/store-file-uploads-in-database but no luck , My form is multipart but still getting the error. Please bare with me I am new to ruby and rails. Here is the like for my

Hi friends in PHP there is a direct function GetImageSize(), with it I can easily determine the dimentions of an image file. How can I do in RoR. Please help me out Thanks in advance -------------- next part -------------- An HTML attachment was scrubbed... URL: http://wrath.rubyonrails.org/pipermail/rails/attachments/20060505/13ba1640/attachment.html

I am switching to a composite primary key (string and user ID) from the Rails conventional auto-incrementing integer primary ID. The table is large (2.5 million records) and I''d rather not discard the contents. The composite_primary_key gem doesn''t appear to support altering the table with a migration to do its magic, only creating a table from scratch. So I dumped the table

I have tried to put a flash movie inside of my RoR page and it shows up with nothing on IEPC. It does very well on every other type of browser but does not work with IEPC. I made a folder - "flash" in my public directory and have had the one instance of it point there. Thus my flash directory is www.rails-app.com/flash/flash.swf Is there anything that anyone knows to help out?

Hello, I have write a schema.rb database such as this: ActiveRecord::Schema.define do create_table :arts do |t| t.string :name, :null => false, :limit => 45 end end This file is saved into test/db/schema.rb, and test/config/database.yml is correctly configured with "test_development" database created in a MySQL server. Could you help me to install the content of

Hello list, I am soliciting opinion here as opposed technical help with an idea I have. I've setup a bacula backup system on an AWS volume. Bacula stores a LOT of information in it's mysql database (in my setup, you can also use postgres or sqlite if you chose). Since I've started doing this I notice that the mysql data directory has swelled to over 700GB! That's quite a lot and

How do I best migrate the data? For small databases I can text-edit the dump file from MySQL. The postgresql compatibility switch doesn''t help on mysqldump. Any ideas. Can MySQL export CSV that postgresql can import ? W Fred -------------- next part -------------- An HTML attachment was scrubbed... URL:

Greetings all, This is the first release of the SuperImage plugin. The idea is you upload images to the database, and then pull them out at any size you want. Combine this with caching and it will stay light and fast. More info and instructions are here: http://beautifulpixel.textdriven.com/articles/2006/04/27/superimage-plugin-making-resizeable-uploaded-images-easy svn:

I''m having an encoding problem, even though I''m attempting to have all my data always be in utf-8. Here''s the path the data takes: I have a CSV file that I believe is in utf-8, because I''m looking at it in a hex editor. One of the words is: 64 65 62 74 6F 72 E2 80 99 73 which translates to: debtor’s [that is, it contains a smart apostrophe] Now,

Hello group, I'm having a very hard time rsyncing efficiently a MySQL database which contains very large binary blobs. (Actually, it's the database of Mantis bug tracker [http://www.mantisbt.org/], with file attachments stored directly in the table rows. I know it's a bad idea from many other reasons, but let's say it was given to me as such.) First, I was dumping the

Hello All, I am trying to upgrade MySQL on CentOS 4.5 but having a hard time. I need to go from MySQL 4.1 to 5. I downloaded the following two files: mysql-server-5.0.58-1.el4.centos.i386.rpm mysql-5.0.48-2.el4.centos.i386.rpm I tried to do: yum install mysql-server-5.0.58-1.el4.centos.i386.rpm And get: Setting up Install Process Setting up repositories Reading repository metadata in from