Backup your batabases w/o phpmyadmin

Alessandro Crugnola general , , , , , ,

I often read threads about export/import data from MySQL and it’s always mentioned phpmyadmin as the only way to do that (with PHP indeed).
But that’s not true, and it’s indeed the slower way to do that, expecially when importing large database files (because phpmyadmin has problems with large db)…
This would be just a reminder 🙂
Use an SSH client, like putty (if your database is on a remote server), to connect to your server and export the databse you want simply with:

mysqldump –user=username –password=1234 –databases your_database –opt –quote-names –allow-keywords –complete-insert | bzip2 -c > your_database.sql.bz2

download the .bz2 file created, unzip it using 7-zip (if you dont have any other uncompress utility), and backup your database in mysql using:

mysql –user=username –password your_database < your_database.sql

that’s faster than using “import” from phpmyadmin
http://dev.mysql.com/doc/refman/5.0/en/mysqldump.html

IE’s ActiveX D-Day

Alessandro Crugnola general ,

As Microsoft announced time ago, the next generation of Internet Explorer will change the way the browser handles ActiveX controls with a significant impact on how online advertising and streaming media content is delivered over the Internet.
The software maker plans to give Web developers an extra 60 days to continue making preparations.
The big push now is for developers to recode Web sites and Web applications to cater for the browser update. If not, users won’t be able to directly interact with Microsoft ActiveX controls loaded by the APPLET, EMBED or OBJECT elements without first activating the user interface with an extra mouse click.
Get the Internet Explorer 7 beta preview


http://www.eweek.com/article2/0,1895,1943847,00.asp

MySQL Workbench 1.0.5

Alessandro Crugnola general , ,

MySQL has released some days ago a new tool for Database Design.
It can handle tables, stored procedures, functions, triggers and views of your existing databases (using the reverse engineering command).
Some features:
– Reverse engineering of existing MySQL databases
– Import DBDesigner4 models
– Synchronize edited model with MySQL database
– Generate SQL create script file
– Printing (Windows)
– Powrefull scripting and plugin interface. Plugins can be written in several languages, such as Lua, PHP, Java and
Python.
– Fast, OpenGL based graphical canvas
It is available for Windows, Linux and MacOSX too.
There’s also the source code free for download.
I found also a very nice Database tool, with tons of features, even if the GUI is not really usable (in my opinion): Aqua Data Studio 4.5
In these days I worked a lot with MySQL 5 and it’s new features and I found those tools very comfortable for my needs.
I hope my hosting provider (mediatemple) will upgrade mysql server too, which is still the 3.23.58!
http://forums.mysql.com/read.php?98,73820,73820#msg-73820

AMFPHP 1.2 released

Alessandro Crugnola amfphp

It’s not really a today news, in fact Patrick released the new version of AMFPHP on 26 of February, but I was so busy in the last weeks…
There’s a really improved service browser, here you can see a live demo, where you can test directly your methods via the web interface.
There is a final note of the author about this release:

A word of caution: I have fixed a bug with sql adapters which may have introduced some other issues. As I only have access to MySQL, these changes are largely untested except for the mysql adapter, so if you use another database, please test your functions using the service browser and report any issues my way.

http://sourceforge.net/project/showfiles.php?group_id=72483

Infragistics Alignment Manager

Alessandro Crugnola actionscript , , ,

For who is familiar with sizers there’s no need to explanation.
I was noticed about this component and after a quick look at the online demo I was conviced to download and try it.
I must say the component inspector ir really well done. It can remember in some way Visual Studio’s inspector for components alignment..
It allows you to easily manage your movieclips on the stage once the stage has been resized.
An example of this behavior, the way sizers work: look at Image Gallery3, navigate and try to resize the borwser window. You’ll see that all the objects on the stage change their position according with the window size…
In order to download Alignment manager you need to fill a registration form: http://www.infragistics.com/..code=NAISAM
http://www.infragistics.com/design/

Gtalkr

Alessandro Crugnola general , , ,

Anybody using Gmail? How about Google Talk?
If so, 2Entwine has created a truely awsome Flash App called Gtalkr!! Right now it is Beta 2.0.0.67, but in my opinion a very promising RIA (Rich Internet Application).

  • Google Talk contact information
  • Contact presence changes
  • Gtalkr Notifier integration
  • Drag and drop support

It lists friends, your Gmail Account, a Flickr slideshow, a YouTube component, and much more…
Still not enough? Well Gtalkr also has a blog, Everything Gtalkr that will keep you up to date!!
Still want more? Well it even supports extensions!! A combination of XML and Flash…”you’ll need to create the Flash file that Gtalkr will load.”
I see a lot of potential in this application and fresh view on customization that other portal technologies lack….
https://gtalkr.com/

Debugging PHP with XDebug

Alessandro Crugnola php , , , ,

In these days, working with PHP after a lot of time, I’ve installed this cool tool for debugging PHP (it supports both PHP 4 and 5).
XDebug is really useful for debugging PHP, which is usually not really easy to debug, and also easy to install.
It provides a lot of valuable debug informations, for example a full traceback for errors, profilig with memory and CPU usage, profiling functions , etc..
I really suggest to take a look at it!
Both Windows and Linux versions are available for download
http://www.xdebug.org

PHP5: a big failure ?

Alessandro Crugnola general, php , ,

What’s happening ?
PHP 5 has been presented as a revolution, a lot of new features have been added and a lot of projects have been made. But only a small group of hosters seem interested in supporting PHP 5 on their web servers. It is not so useful to have a beautiful programming language to use if we can’t apply it to production environments.
But what about the causes ? Maybe they are related to the fact that Zend decided to support both PHP 4 and 5 separately, allowing hoster to choose which version to compile on their webservers, or maybe to the fact that PHP 5 is not fully compatible with the older versions, and there are some security-related bugs that increase our doubts.
I’m using a lot PHP 5 in production environments, without any problem. It is quite fast and reliable, and has got a lot of useful features that adapt perfectly to enterprise development. We MUST use PHP 5 to help it growing until it become the standard …
To conclude I’d like to inform the ones who don’t know it, that PHP team is working on the sixth version (yes … PHP 6 … and it is available for download at snaps.php.net) that will add to the language a lot of interesting features, such as native support to Unicode.
I hope there will be only one (working) version of PHP in the future …