tag:blogger.com,1999:blog-53170951073462899482024-03-13T15:07:22.492-07:00Ruby on Rails 4.0Unknownnoreply@blogger.comBlogger2125tag:blogger.com,1999:blog-5317095107346289948.post-82459686581012158422011-08-20T10:26:00.000-07:002011-08-20T11:01:59.611-07:00Rails Application With Our Own Database<div dir="ltr" style="text-align: left;" trbidi="on"><div class="separator" style="clear: both; text-align: center;"><a href="http://2.bp.blogspot.com/-vFzd9_Zhff4/Tk_q904B-wI/AAAAAAAAADI/KzpdKkVFrlg/s1600/rails_app.jpg" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" height="227" src="http://2.bp.blogspot.com/-vFzd9_Zhff4/Tk_q904B-wI/AAAAAAAAADI/KzpdKkVFrlg/s320/rails_app.jpg" width="320" /></a></div><span class="Apple-style-span" style="font-family: 'Trebuchet MS', sans-serif;"><br />
</span><br />
<span class="Apple-style-span" style="font-family: 'Trebuchet MS', sans-serif;">If we are working with rails version 2.X.X , the rails framework automatically create an application with sqlite as a default database. If we want to create the rails application with our selected database by using the following command..</span><br />
<span class="Apple-style-span" style="font-family: 'Trebuchet MS', sans-serif;"><br />
</span><br />
<span class="Apple-style-span" style="font-family: 'Trebuchet MS', sans-serif;"><span class="Apple-style-span" style="background-color: white;"><span class="Apple-style-span" style="color: magenta;">Syntax </span></span>: rails -d database_name app_name</span><br />
<span class="Apple-style-span" style="font-family: 'Trebuchet MS', sans-serif;"><br />
</span><br />
<span class="Apple-style-span" style="font-family: 'Trebuchet MS', sans-serif;"><span class="Apple-style-span" style="color: #cc0000;">Example</span> :</span><br />
<span class="Apple-style-span" style="font-family: 'Trebuchet MS', sans-serif;"><br />
</span><br />
<span class="Apple-style-span" style="font-family: 'Trebuchet MS', sans-serif;">rails -d mysql depot </span>(OR) <span class="Apple-style-span" style="font-family: 'Trebuchet MS', sans-serif;">rails shopping_cart -database=mysql</span><br />
<span class="Apple-style-span" style="font-family: 'Trebuchet MS', sans-serif;"><br />
</span><br />
<span class="Apple-style-span" style="font-family: 'Trebuchet MS', sans-serif;">Here, depot and shopping_cart are the application names which we are going to create for rails.</span></div>Unknownnoreply@blogger.com2India20.593684 78.9628800000000416.071455499999999 64.319952500000042 35.1159125 93.60580750000004tag:blogger.com,1999:blog-5317095107346289948.post-79100346516687879312011-02-03T06:18:00.000-08:002012-01-29T23:30:11.777-08:00How to import huge data file to MySQL<div dir="ltr" style="text-align: left;" trbidi="on"><div style="font-family: Verdana,sans-serif;"><span style="font-size: small;">Recently I have a problem while importing the database file to mysql database using phpmyadmin. My file size has huge amount than they given. i.e. my file has morethan 2.5 MB. </span></div><div style="font-family: Verdana,sans-serif;"><span style="font-size: small;"><br />
</span></div><div style="font-family: Verdana,sans-serif;"><span style="font-size: small;">For this, I have import and export data to database by using the following commands.</span></div><div style="font-family: Verdana,sans-serif;"><span style="font-size: small;"><br />
</span></div><div style="font-family: Verdana,sans-serif;"><span style="font-size: small;">1) <b>Import data to my database</b></span></div><div style="font-family: Verdana,sans-serif;"><span style="font-size: small;"><br />
</span></div><div style="font-family: Verdana,sans-serif;"><span style="font-size: small;">E:\> mysql -u "mysql_user_name" -p"mysql_password" myapp_development < rails_backup.sql </span></div><div style="font-family: Verdana,sans-serif;"><br />
</div><div style="font-family: Verdana,sans-serif;"><span style="font-size: small;">2) <b>Export Data from database as sql file</b></span></div><div style="font-family: Verdana,sans-serif;"><br />
</div><div style="font-family: Verdana,sans-serif;"><span style="font-size: small;"> E:\> mysql -u "mysql_user_name" -p"mysql_password" myapp_development > rails_backup.sql</span></div><div style="font-family: Verdana,sans-serif;"><span style="font-size: small;"><br />
</span></div><div style="font-family: Verdana,sans-serif;"><span style="font-size: small;">Here "myapp_development" is my database name.</span></div></div>Unknownnoreply@blogger.com2