On Fri, Jan 11, 2002 at 04:48:18PM +0530, Manish Mehta wrote: > Hi, > > I am new to test case design in Database. > > I wants to know Basically how to calculate the Maximum Database.
A database can consist of several tables. Each table is stored (essentially) as a file. The size of a that file depends on a) your operating system, and b) which table type you use. See the list's archives for some specific numbers. > When we have to take backup.? What do you mean by 'backup'? Copying the database's files directly to tape? That depends on your computer's disk subsystem, and what you're writing them to. 'Dumping' the database to a file? That also depends on your computer's disk subsystem, and might also be limited to your CPU and how much physical memory you have. > What are steps to be flow please tell me. The 'best' thing to do, for whatever methods your speaking of, is: 1) install MySQL on the hardware where all of this would take place; the software is freely available. 2) create a database and a table, and try to fill it; shouldn't take more than a couple of hours, assuming you're willing to cobble a script together. 3) try to back up the database you just created. Honestly, your own experiments will give you the most concrete numbers, given the hardware and methods you have... > Thanks in advance..................... > > Manish Mehta > E-mail: [EMAIL PROTECTED] -- Brian 'you Bastard' Reichert <[EMAIL PROTECTED]> 37 Crystal Ave. #303 Daytime number: (603) 434-6842 Derry NH 03038-1713 USA Intel architecture: the left-hand path --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
