-
What, who, where am I?!?
Craig Lotter is a web developer based in Gordon's Bay, South Africa, who seems completely incapable of shaking off that pesky inner child within, the one that forces him to love all things animated or hand drawn.
The Rugged Rock of Craig contains snippets of his life, popular culture and all the important things like anime, manga, games and comic books. The CodeUnit of Craig on the other hand contains the more serious stuff like code snippets and tutorials, while the House of C chronicles his foray into the world of web comics.
For which it never seems he has enough time anyway.
CodeUnit Post Archive
Tag Archives: database
How to Duplicate a Table in FlameRobin
FlameRobin is a lightweight, cross-platform database administration tool for Firebird databases. It is also NOT one of my favourite tools to use because of its very lightweight nature! Nevertheless, there are times I must use it, and use it I … Continue reading
Posted in Tutorials
Tagged copy, database, dbms, duplicate, firebird, flamerobin, Open Source, table
1 Comment
Ubuntu Terminal: Efficient Way to Copy Across a MySQL Database from One Server to Another
I often need to pull down a copy of a live MySQL database instance for development work on my local machine. Because my access to bandwidth is limited, I need to come up with the most efficient way of achieving this, and my method for achieving this is chronicled below – mainly so that I can refer to it when I forget! Continue reading
MySQL: How to Show the Collation and Character Set of a MySQL Database
To find out what collation and character set your database is using turns out to be pretty trivial thanks to MySQL’s SHOW VARIABLES SQL statement that reveals all the inner workings of your setup. Continue reading
Ubuntu: How to Delete a MySQL Database via the Terminal
To delete a database from a MySQL server instance, we need to make a DROP DATABASE call against the server. Continue reading
Posted in MySQL, Tutorials
Tagged database, delete database, mysql, terminal, Ubuntu
Leave a comment
Ubuntu Terminal: How to Quickly Create a SQL Dump File from a MySQL Database
Backing up your MySQL database or generating a copy of it to shift around is quite a simple affair thanks to the powerful mysqldump command that ships with MySQL. Continue reading
Posted in Software & Websites, Tutorials
Tagged backup, command line, database, Linux, mysql, sql dump, terminal, Ubuntu
2 Comments
