Hello.
Login as root though mysql command line client and check if new tables exist and if you're able to work with them. Under what user are you working in phpMyAdmin? Does he have some privileges on just created databases or 'SHOW DATABASES' privilege. See: http://dev.mysql.com/doc/refman/5.0/en/show-databases.html > Assuming that I get this part figured out, is it possible to also > update the _mysql_.sql database so that all of the mysql users with > mysql permissions to those databases will be replicated, as I had them > on the other machine? You may just copy mysql database as any other database. Then if you're upgrading from the old version you may have to invoke mysql_fix_privileges script. See: http://dev.mysql.com/doc/refman/5.0/en/upgrading-grant-tables.html Curious George wrote: > Greetings all, > I've got some headaches I need to make go away over the weekend. I > used phpMyAdmin to backup some small mysql databases. (So I've got a > bunch of _dbname_.sql files) > > I have a different machine with a newer version of MySQL (4.1.13a) > running and configured so that I can connect from the command line (as > -u root) or via phpMyAdmin. I've copied the _dbname_.sql files to the > new server. Now, from the UNIX prompt, I'm doing a: > [terminal]mysql -u root -p emptydatabase < _dbname_.sql[/terminal] > I get no errors, but when I go back to look at the database (using > phpMyAdmin - reloading the page) there are still no tables in > emptydatabase. > > What am I doing wrong? > > Assuming that I get this part figured out, is it possible to also > update the _mysql_.sql database so that all of the mysql users with > mysql permissions to those databases will be replicated, as I had them > on the other machine? > > I should probably mention that phpMyAdmin is on the same machine as > the MySQL 4.1.13a and is connecting via TCP (not socket). I'm logged > into the machine as Admin. My MySQL database directory (/var/mysql) > AND EVERYTHING INSIDE IT has been chown'd to mysql:www. The /var/mysql > directory is 755. > > If there is something wrong with my setup/permissions or any other > part of what I'm doing here, please let me know. I have never moved > databases before (obviously). > : \ > > Thanks in advance for any insights! > -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.NET http://www.ensita.net/ __ ___ ___ ____ __ / |/ /_ __/ __/ __ \/ / Gleb Paharenko / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.NET <___/ www.mysql.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
