My Work
My Blogs
Hotlinks
Tag Archives: cli
Today I took 30 minutes to save hours
UPDATE – 1/6/2011 : Since writing this post I have bundled this entire reset process into a single windows batch file. In addition to restoring my database, I also have to remove temp files from my server, so it was … Continue reading
Posted in database, development, SQL, tips and tricks
Tagged automation, backup, bat, batch, batch file, cli, cmd, command line, cursor, DECLARE, del, exec, fetch, fetch_status, information_schema, kill, restore, sproc, SQL, sqlcmd, sys, tsql, workflow
Leave a comment
Copy a MySQL database to your local MySQL machine
Here’s one way to copy a MySQL database from one server to another using phpMyAdmin, and the MySQL command line client. Requirements : MySQL 5.x installed on your local machine MySQL command line client on your local machine Access to … Continue reading
Posted in command line, database, SQL, tips and tricks
Tagged cli, copy database, dump file, export database, import, import database, mysql, mysql5, phpMyAdmin
Leave a comment
