Contact US

Log In

Come Join Us!

Are you a
Computer / IT professional?
Join Tek-Tips Forums!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!

*Tek-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.

Students Click Here

moving mysql-data files?!

moving mysql-data files?!

moving mysql-data files?!

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?


RE: moving mysql-data files?!

Did you dump out the data properly?  You can do this use mysqldump -u [username] -p[password] [database name] > [filename]

like example
mysqldump -u username -ppassword database > database.sql

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.

RE: moving mysql-data files?!

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...

RE: moving mysql-data files?!

I think mysqlimport is only for importing .CSV (comma-separated values) text files, not SQL statements.

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:

mysql -u username -h hostname -p yourdatabase< yourSQLfile.sql

The -p option will prompt for password before running the script. You can also include the password in plain text as in:

mysql -u username -h hostname -pPassword yourdatabase< yourSQLfile.sql

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.

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 http://www.phpwizard.net

Hope this helps...

Red Flag This Post

Please let us know here why this post is inappropriate. Reasons such as off-topic, duplicates, flames, illegal, vulgar, or students posting their homework.

Red Flag Submitted

Thank you for helping keep Tek-Tips Forums free from inappropriate posts.
The Tek-Tips staff will check this out and take appropriate action.

Reply To This Thread

Posting in the Tek-Tips forums is a member-only feature.

Click Here to join Tek-Tips and talk with other members! Already a Member? Login

Close Box

Join Tek-Tips® Today!

Join your peers on the Internet's largest technical computer professional community.
It's easy to join and it's free.

Here's Why Members Love Tek-Tips Forums:

Register now while it's still free!

Already a member? Close this window and log in.

Join Us             Close