I've moved my database, which is rather large to another machine, which is not on a network but has mysql for win installed. I'm using phpadmin to manage tables and stuff. it shows all table-meta-data, but whenever I try to "browse" through the data of the tables, I get an error from mysql "134". I couldn't look up this error code anywhere - does anyone know what it means?<br><br>thanks<br>
Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations Chris Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
moving mysql-data files?!
- Thread starter panza
- Start date
adelinewss
Programmer
Did you dump out the data properly? You can do this use mysqldump -u [username] -p[password] [database name] > [filename]<br><br>like example <br>mysqldump -u username -ppassword database > database.sql<br><br>The command above will dump the database named database to database.sql. After that you can run your sql command from database.sql. Hope this would help.<br>
- Thread starter
- #3
I think mysqlimport is only for importing .CSV (comma-separated values) text files, not SQL statements.<br><br>I'm not sure if it works the same on a Windows system, but in Unix, the contents of your sql statements can be piped in this way:<br><br>mysql -u username -h hostname -p yourdatabase< yourSQLfile.sql<br><br>The -p option will prompt for password before running the script. You can also include the password in plain text as in:<br><br>mysql -u username -h hostname -pPassword yourdatabase< yourSQLfile.sql<br><br>If that doesn't work in Windows, the latest version of phpMyAdmin lets you browse for a SQL file to execute. Failing that, you can even open your whole SQL file in a text editor, highlight and copy to clipboard, and paste into the phpMyAdmin query area. You might also benefit from breaking the files down into smaller chunks.<br><br>P.S. I don't know if by phpadmin in your first post you meant the same thing as phpMyAdmin, but if not, it's pretty much the best web-based admin system for MySQL. Get it at <A HREF=" TARGET="_new"> this helps...
- Status