srpa01red

how can we take backup of a database with shutdown the server in mysql.

hi how i can restore database from binarylogs what is the procedure. i had taken a backup and inserted data into the database. now i want to take a incremental backup. i had a binlog as mysql-bin.000013 i am using mac os10.5

hello hi i am using mac osx 10.5 i want to start mysql in it with --log-bin option so as to take incremental backup.so how can i start mysql with that option. i start mysql as mysql -u root -p. plz help me. where can i find my binlogs

hi all i had taken backup of my database and added some tables so as to take inc.backup i had a binary log as mysql-bin.000001 now i want to make a incremental backup from it. plz help me how can i use this log for inc.backup in mysql

Currently connected to remote server but remote configuration is not yet possible this is msg shown when trying to connect remotely to a database what does it means

plz give me a brief description how to take a incremental backup

hello i got this error while taking a backup in mysql usung mysql administrator Error Performing Backup: Could not open file for writing backup. what does it mean how can i get rid of it the error at last table to be backedup

how can i find size of my database what is the max table size in mysql is table size shown is in terms of kb or mb in mysql by default actually dis is the max_data length shown using "show table status" 281474976710655. means data size is shown in kb …

i want to insert into table some dummy data so as to large my database is there any script or procedure in mysql to execute a insert statement about some thousands times

mysqldump: Got errno 28 on write what is this error . plz give me a solution for it

i want to insert dummy data for testing my database.so i want to execute a single insert statement 1000 times. is there any function to do so or is there any script todo. if so plz help me

how can we check whether the primary and foreign key are working in the database in mysql

hai i want a shell script to load data from a csv file into mysql table plz reply me soon urgent

i had a table categories(cid int primekey,name varchar,description text,parent_id,created date,updated date) i want a script for insertion like this insert into categories(...) values(cid value,name value,..desc, parent_Id..); can i write the statement as insert into categories(....) values (1,'aaa','some text',[U]select parent_id from categories where parent_id=id[/U],date,date); just i wana know how can i …

i had a table categories category_id parent_id industrial null automotive null petrol industrial bikes automotive diesel industrial tankers automotive ....so on ihad another table CATEGORY_PRODUCT with fields(category_id) in this table i want to insert the category_id from category table as if parent_id=null then insert category_id as parent_id if parent_id !=null …

i had a table productcs with stucture as pid,name,description,applications,created_at as datetime,updated_at datetime. i will load the data from a csv file.now i want to insert the current timestamp while loading the data i.e the present time at which i am loading the data .is it possible to insert the current …

i want to insert data into third table for two tables that is first table:table struct: pid -->int,name-->string ..etc second table :cid -->int,parentid-->int....etc third table struct is:pid-->int,cid-->int now iwant to insert data into third table from the other two tables pid from first table is a prime key and pid …