[DUG-TO] cache_form important?

[Andrew Mallis]

Sounds like you're using MAMP and phpMyAdmin.
Use the command line to import. It's 10000 times faster:


$ /Applications/MAMP/Library/bin/mysql -umyusername -pmypassword  
database_name < datbase_BU.sql

or, if you have a compressed archive:

$ gunzip < database_BU.sql.gz | /Applications/MAMP/Library/bin/mysql - 
umyusername -pmypassword database_name



you can make a symbolic link to the MAMP mysql binary somewhere in  
your PATH to make the commands easier

$ ln -s /Applications/MAMP/Library/bin/mysql /usr/local/bin/mysql

this way you just need to type:

$ mysql -umyusername -pmypassword database_name < datbase_BU.sql


If you're not using MAMP but have a locally compiled MySQL, then the  
last command is the one you want anyhow.

Hope this helps.


bonus: command-line mysql dump from MAMP

# alias mysqldump somewhere in your path, if it isn't there already
$ ln -s /Applications/MAMP/Library/bin/mysqldump /usr/local/bin/ 
mysqldump

# dump and compress your DB with a date suffix.
$ mysqldump -u myusername -pmypassword -h localhost --opt  
database_name | gzip -v -9 >/path/to/file/database_name.$(date +"%F_%H. 
%M").sql.gz



Andrew Mallis
http://andrewmallis.com
skype: andrew_mallis  |  gTalk/Jabber:  andrew.mallis

462 Delaware Avenue
Toronto  |  Ontario   |  M6H 2T9
h:    416-533-2132
c:    416-939-4502






On 27-May-09, at 4:01 PM, Carole St. Laurent wrote:

> I'm stuck unable to import cache_form into my local DB. My Mac is  
> dreadfully slow, it dies without any records importing at all, even  
> though partial imports are allowed. I also upped my max query time  
> to a dreadfully slow interval. Nothing helps. Do I need this table,  
> or can I load an empty version & will it recreate locally fine?
>
> Anyone having 1and1 DB problems? I am consistently this week.
>
> thanks
>
>
> Carole St. Laurent
> Internet Consultant
> fluidIT solutions
> ----------------------------
> "Increase your impact through creative technical strategies."
> carole at fluidITsolutions.com
> +1 (416) 762-2245
> www.fluidITsolutions.com
>
>
> _______________________________________________
> DUG-TO mailing list
> DUG-TO at lists.openject.com
> http://lists.openject.com/listinfo/dug-to