Click to Play Dealing with Load Balancing Issues As most everyone knows, large and complex websites require a lot of hosting systems. Unfortunately, a problem occurs since many hosting systems create... Recent Articles Oracle Pledges To Up Investment In MySQL An organization with a market cap in the neighborhood of $130 billion will soon be taking a renewed interest in MySQL. The chief corporate architect of Oracle... Comparing NoSQL And RDBMS For Large Database... The last few weeks I have witnessed a ton of passionate debate about what is better, NoSQL or RDBMS. It almost sounds like a religious battle between Windows and Mac fan-boys. To me this is like arguing that... Using YQL To Connect With Large Groups Of APIs A few days ago I spotted a Twitter conversation between Simon Whatley and Christian Heilmann which brought YQL back into my mind. In case you don't know... DiscountASP.NET Improves Security Of SQL... DiscountASP.NET, a Windows shared hosting firm, has announced improved security of their SQL Server hosting platform through the support of SSL encrypted SQL communication with SQL 2008 and SQL...

05.06.10 Using MySQL Workbench To Copy/View/Edit/Test A Remote Website Locally By Alex Trent This guide is designed to be used for Linux desktops and servers. For best results, use the same Linux version for the desktop as is installed on the server. To quote the authors: MySQL Workbench is a cross-platform, visual database design tool developed by MySQL. It is the highly anticipated successor application of the DBDesigner4 project. MySQL Workbench will be available as a native GUI tool on Windows, Linux and OS X. http://wb.mysql.com/?page_id=6 Take a look at the screenshots here: http://wb.mysql.com/?page_id=35 Exporting the database and website Use the following command to export the database from the server: ?mysqldump -u USER -p DATABASE > FILENAME.sql Then zip the folder of the website, using the command: tar czvf WEBSITEFOLDERNAME.tgz WEBSITEFOLDERNAME Now copy the SQL file and the tar/gzipped website from the server to your Linux Desktop. Be sure to copy any config files for the webserver from /etc/apache2 and /etc/php5. Importing the database Install MySQL Server: On Debian/Ubuntu systems use: sudo aptitude install mysql-server See the MySQL website for other versions of Linux: http://dev.mysql.com/downloads/mysql/ Import the SQL file into the database: ?mysql -u USER -p DATABASE < FILENAME.sql Download and install the latest release of MySQL Workbench here: http://dev.mysql.com/downloads/workbench/5.2.html Viewing/Editing the data Open MySQL Workbench and follow the steps to setup a connection to local host: http://www.ghacks.net/2009/12/25/complete-database-administration-package-mysql-workbench/ In MySQL Workbench viewing/editing a table is as simple as right clicking on the table in the object window and left clicking on ‘Edit Table Data‘ in the pop-up menu. Continue reading this article. About the Author: Alex Trent is a staff writer for WebProNews

SQLproNews is brought to you by: SecurityConfig.com NetworkingFiles.com NetworkNewz.com WebProASP.com DatabaseProNews.com SQLProNews.com ITcertificationNews.com SysAdminNews.com SQLproNews.com WirelessProNews.com CProgrammingTrends.com SysAdminNews.com About SQLproNews SQLproNews is a collection of up to date tutorials and insightful articles designed to help SQL users of any skill level implement successful SQL systems and practices. SQL Strategies and Tactics for Business

-- SQLProNews is an iEntry, Inc. publication -- iEntry, Inc. 2549 Richmond Rd. Lexington KY, 40509 2010 iEntry, Inc.  All Rights Reserved  Privacy Policy  Legal advertising info | news headlines | free newsletters | comments/feedback | submit article