Evening, I'm using MySQL (4.1) as an index storage with the default MyISAM table format. Unfortunately the partition holding the MySQL databases ran full and the database became corrupt. So I wanted to restore the mysqldump of the index from the day before.
Now it's 12 hours after I started to restore the 2.4 GB dump file and MySQL still seems to be doing the "/*!40000 ALTER TABLE `File` ENABLE KEYS */" part of the dump. The disk is trashing like fury while the database is creating the indices. What I wonder about: - is > 12 hours a common restore time for a 2.4 dump file? - is a 2.4 dump file/database size common when backup up ~1 million files that sum up to ~50 GB? (file and job retention are 1 month while I run one full backup per week and an incremental daily) - is InnoDB perhaps suited better than MyISAM? - are there MySQL server parameters I could tune? - are there better ways to restore the database than "mysql < dumpfile"? - is PostgreSQL (7.4.7) perhaps better suited? It also appears that while running a backup the database is extremely busy leaving little computing power for the actual backup. The disks are common IDE disks running in a Pentium 4/2.4 GHz with 512 MB RAM. I'm a bit worried about the scalability because this is just a single file server I use for mainly private use plus a little development. How do people operate Bacula and MySQL in really large environments? Another non-related question that came to my mind: can I assign certain network clients a certain "bacula client" to restore? Currently every client can choose from the list of all clients for restoration. And while I was asked to include further workstations in the backup I worry that they could be restoring files I don't want them to get access to. Kindly Christoph ------------------------------------------------------- Using Tomcat but need to do more? Need to support web services, security? Get stuff done quickly with pre-integrated technology to make your job easier Download IBM WebSphere Application Server v.1.0.1 based on Apache Geronimo http://sel.as-us.falkag.net/sel?cmd=lnk&kid=120709&bid=263057&dat=121642 _______________________________________________ Bacula-users mailing list Bacula-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/bacula-users
