moving mysql-data files?!

[panza]

I've moved my database, which is rather large to another machine, which is not on a network&nbsp;&nbsp;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 &quot;browse&quot; through the data of the tables, I get an error from mysql &quot;134&quot;. I couldn't look up this error code anywhere - does anyone know what it means?<br><br>thanks<br>

 

[adelinewss]

Did you dump out the data properly?&nbsp;&nbsp;You can do this use mysqldump -u [username] -p[password] [database name] &gt; [filename]<br><br>like example <br>mysqldump -u username -ppassword database &gt; database.sql<br><br>The command above will dump the database named database to database.sql.&nbsp;&nbsp;After that you can run your sql command from database.sql.&nbsp;&nbsp;Hope this would help.<br>

 

[panza]

yes, I got a dump in form of sql-statements. how do I run these (huge) sql-statements to build the new database? mysqlimport doesn't seem to work properly with files...

 

[rycamor]

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&lt; 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&lt; 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="

http://www.phpwizard.net"

TARGET="_new">

http://www.phpwizard.net</A><br><br>Hope

this helps...