Re: How to?
On Tue, 24 Aug 2004 11:57:42 +0100, A Z wrote: An existing database table structures has changed, I want to create the same database with new table structures. I do not want to lose any data. How can I do this? do a backup how? Sure.. There are several ways to accomplish this. 1. Create new tables under a new user. Copy data from olduser.tablename to newuser.tablename. 2. Export data, and reload data. 3. (for some type of changes) Alter table 4. Dump the table username.dmp. Alter the file to the new schema, manipulate sql insert statement to convert the data. [make sure that you keep a clean copy of the original data.] source the dump file \. username.dmp and of course there are many varations on a theme. you are only limited by your imagination (and time...and money...) -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
user permissions on test ( DBD::mysql)
In previous installs, I've never been able to do it 'right' but fresh install (4.1.1), new machine. So I'd like to set it up so perl Makefile.PL on modules will install without having to pass special parameters to build process. First. mysql_install_db sets up the test db so that the anonymous user (that is any machine identifer user who is not identified to mysql) has all the privledges that are need to test. But at the point of testing, it is required that [EMAIL PROTECTED] have an empty password to test against the 'test' DBS. As soon as the database is installed, most root accounts have a significant password. How can I setup a user 'root' to grant all priveledges on test -and- having a null password? while still protecting the other databases? [[ Installing modules in Perl generally requires root level privledges and so root is -never- an anonymous mysql user. ]] is there a way to set things up so that a standard set of parameters can be passed to perl Makefile.PL to generate a successfull make test situation (consider perl -MCPAN -e shell) -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
