text_combined: robert sweetnam sgjavsweetnameu hamilton david tsg ci wrote looking create mysql database moved around system system see create database directory name created data directory required run database assuming base config files need able take db external disk reconnect mount point another system able start im coming oracle perspective every db needs initora file thanks david dump entire contents database sql file mysql comes utility called mysqldump would use follows mysqldump database name dumpsql works mysql root user password another mysql user permissions database would use mysqldump u user p database name destinationsql prompted password import dump would use following mysql database dumpsql using u p switches needed dump contents remote mysql server database machine would use mysqldump h hostname u root p database dumpsql restore mysql h hostname u root p database dumpsql cheers robert fri 08 aug 2008 012638 0000 ilug mysql database question