備份
1.先進入cmd
2.切換到下列目錄(依據不同MySQL版本，路徑可能不同)
C:\Program Files\MySQL\MySQL Server 5.1\bin
3.執行下列指令
mysqldump -uroot -pa12345 -hlocalhost --default-character-set=utf8 -A > backup.sql
root:代表使用root帳號
a12345:此處請自行改為root的密碼
localhost:代表要備份本機的MySql資料庫
backup:備份完成的檔案名稱
utf8:請先進到MySQL Command line Client 輸入status或\s查詢
完成後會在相同目錄下出現backup.sql，把這個檔案存起來即可
--------------------------------------------------------------------------------------------------------
還原
同上步驟1及2
3.執行下列指令
mysql -uroot -pa12345 < backup.sql
紅字部份同上
資料參考來源: Acoak Blog
MS-SQL 無法刪除使用者 - 資料庫主體在資料庫中擁有 結構描述 且無法卸除。(Microsoft SQL Server, 錯誤: 15138) 在設定MSSQL時，很常把結構描述跟成員資格搞錯 這是結構描述 這是成員資格 成員資格是設定權限用的，結構描述...我不太清楚 X...
-
在SELECT語句中，增加一個欄位，可以自動編號1, 2, 3 SELECT ROW_NUMBER () OVER ( ORDER BY id) AS rowNo, id, Name FROM Table1 結果如下: rowNo id ...
-
最近突然發現Windows工作管理員(Task Manager)的處理程序變成一片空白，無法正常顯示；雖然沒什麼大問題，但總覺得麻煩，有時候想看系統資源被什麼程序吃掉，就看不到了，問題畫面如下： 依照 微軟的建議 ，以系統管理員方式執行cmd 執行DISM的掃描指... -
目前使用Windows 10 1803版本，看起來已沒有界面可調整，必須在Registry中自行設定。 路徑： \HKEY_CURRENT_USER\Software\Microsoft\TableTextService\0x00000404\ 裡面應該會有一串GUID的...
QuickBooks is used to complete the work related to your accounts like managing salaries, taxes, returns, attendance, etc. You can also share your accountant’s file to your clients, but it is showing errors. You can fix this problem by calling the Quickbooks Phone Number. It is available to attend your issue 24/7 hours and provide your better assistance on call. You can also fix issues by updating your QuickBooks software with a current version. Prepare and create a new accountant’s file again and share it with your client. If it is shared then, you have removed this problem.
回覆刪除Read More : QuickBooks is Unable to Display the Accountant's Changes
Use Payment and Adding Items and Categories in GoPayment QuickBooks
How to resolve QuickBooks error 6000
How to Fix Quickbooks Update Error Code 12007
How to void a check in QuickBooks
How to Manage QuickBooks Bill Online
QuickBooks Unable to Connect to Remote Server
Sometimes, you face difficulty in e-filing your tax returns after being rejected by the Internal Revenue Service. You have to follow a few tips to fix return rejections. Type the correct SSN that matches with your details on the tax form. Enter the accurate information of your family members for which you are going to the e-file tax return. Apply your tax return separately by emailing the IRS if your dependent has applied to the TurboTax e-file tax return facility. If there is any issue in putting these tips to troubleshoot rejection, then call Turbotax Helpline Number
回覆刪除Read More : How Do I Fix A Rejected Return On TurboTax
Related Post : Fix TurboTax Error Code 65535 | Install TurboTax With or Without CD/DVD on Windows 10