sql graph

MySQL diagram tool

Check out MySQL workbench when you get a chance. It has an amazing tool for visualing SQL tables/rows/relationships (foreign keys). I’ve been using navicat for years and never really looked into the tools that oracle came out with. Workbench is nice however and it’s free to check out. Also it has a tool to reverse

Importing large mysql database files

I’mĀ using sed to replace header/mysql create database name and use database. sed -i ‘1,30 s/`parser`/`server_parser`/’ new_parser.sql The above command edits the file in place ( -i ) option. Replaces in the first 1-30 linesĀ  any `parser` with `server_parser`. If this doesn’t work for importing this huge 10 gig sql file im going to use tail